XLGetSheetDims clarification

[SandyDoss]

DISCLAIMER: I AM A TOTAL MACRO SCHEDULER NOOB!

So, let me start by saying that I'm finding your scripting application easier and easier to use as I go along. I've graduated from a simple 'open notepad.exe and write a line' to accessing numerous excel spreadsheets in a directory and using data from specific cells as input to another application on a remote computer. All in just a matter of days. So thanks for taking pity on us older (elderly) coders.

I need clarification on the XLGetSheetDims command - the manual says that it returns the number of rows and columns containing data in a given sheet. However, I have found that the term 'data' may not mean text, numbers or spaces, but may also mean any formatting styles (cell borders, etc). Is this correct?

Thanks,
Sandy

[Marcus Tettmar]

Yes, if the cells have been formatted, then it will count down to the last one formatted. What I usually do when looping through a sheet is always test to see if the cell is empty and break out of the loop if so.

[SandyDoss]

Thanks, Marcus

Appreciate the quick reply