L
Legacy 98055
Guest
Hi
I need the last used cell/row or a total count of all used cells in coumn A.
When the sheet is empy, this line of code assigns the value of 17?
There are currently 25 rows filled with values from A1:A25
Still assigns the value of 17?
What's wrong with the code?
Thanks in advance!
Tom
The search utility is not working on Mr Excel
LastRowUpdate = Workbooks(FileToOpen).Sheets("sheet1").Range("a1:a" & Range("A65536").End(xlUp).Row).Rows.Count
This message was edited by TsTom on 2002-03-27 03:47
This message was edited by tstom on 2002-03-27 03:54
I need the last used cell/row or a total count of all used cells in coumn A.
When the sheet is empy, this line of code assigns the value of 17?
There are currently 25 rows filled with values from A1:A25
Still assigns the value of 17?
What's wrong with the code?
Thanks in advance!
Tom
The search utility is not working on Mr Excel
LastRowUpdate = Workbooks(FileToOpen).Sheets("sheet1").Range("a1:a" & Range("A65536").End(xlUp).Row).Rows.Count
This message was edited by TsTom on 2002-03-27 03:47
This message was edited by tstom on 2002-03-27 03:54