XcelV4
09-13-2009, 12:11 PM
Hi all,
I'm trying to get the last row of a spreadsheet so I can append a small table of data below it. I am attempting to use the UsedRange attribute and the Row and Column attributes of that to get the last used row but when I print these values they always appear as "1" irrespective of the amount of data in the worksheet. I must have misinterpreted what the Row and Column refer to in this case. What do they mean and how can I get the last used row of the spreadsheet?
Cheers All
I'm trying to get the last row of a spreadsheet so I can append a small table of data below it. I am attempting to use the UsedRange attribute and the Row and Column attributes of that to get the last used row but when I print these values they always appear as "1" irrespective of the amount of data in the worksheet. I must have misinterpreted what the Row and Column refer to in this case. What do they mean and how can I get the last used row of the spreadsheet?
Cheers All