Detect if Excel 2008 document contains hidden rows
Detect if Excel 2008 document contains hidden rows
- Subject: Detect if Excel 2008 document contains hidden rows
- From: Bert Groeneveld <email@hidden>
- Date: Thu, 27 Aug 2009 12:11:15 +0200
Question about Microsoft Excel 2008:
When talking to (the active sheet of) an Excel document: Is there a
way to detect if the document contains invisible rows, without looping
through all the rows one by one? Every now and then I meet documents
with thousands of rows. It would be very time consuming looping
through all the rows, just to detect if a single one is hidden. Likely
the rows are made hidden with the Data->Filter->Auto Filter command.
Probably there is some command that detects if this option is turned
on? Hope someone can help, because I am far from an Excel specialist.
Bert.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden