How would I display the used range of an excel spreadsheet?
I tried:
This did not work, so how would I do something like this? Is there also some way to get the total number of used columns and total number of used rows? If you could tell me how to do this in Visual Basic Script that would be great. Visual Basic 6 or VB.Net code is ok. I'm assuming they are going to be similar?Code:MsgBox objExcel.Worksheets(1).UsedRange
Reply With Quote
