If I use
This gets the correct LastRow number for column A, but if I try![]()
lRow = .Cells.Find("*", .Range("A1"), , , xlByRows, xlPrevious).Row
or any other column I get the number 1![]()
lRow = .Cells.Find("*", .Range("B1"), , , xlByRows, xlPrevious).Row
What am I doing wrong or do not understand?
Thanks
Bookmarks