General information
Category:
COM/DCOM and OLE Automation
You can check the .UsedRange.Address property of the sheet object. It will return $A$1 on an empty sheet or you can check cell by cell. Let me know if you need actual coding. I'm sure this is one of a dozen different methods. This one of the reasons I love UT, you get lots of responses with many different methods (hopefully at least one is new to "you").
>I'm working in an import wizard for one of our tables.
>
>I need to know if an Excel spreadsheet is empty, "empty" is simply defined for this work as the file having empty the first row of the first sheet.
>
>How can I programatically check it?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only