I am using ActiveCell.SpecialCells(xlLastCell).Select to point to the last used cell of my excel sheet which was 230. It works only for the first time. The next time, even if my sheet has only 90 rows, the last cell still remains as 230. can you pls help me on this?
Bookmarks