vbscript to open worksheet, insert data on first open cell....HELP.....
GBPackerBacker wrote:
.. look into the last cell of Column A
I think you want:
Dim iRow
To get the row of the last used cell in column A:
iRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
To get the row of the last used cell in the worksheet:
iRow = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row
and you can add 1 to get the next row.
|