I'm new to VBA and stuck on an issue defining the "last row". I defined the last row as the following: LastRow = Cells(Row.Count,1).End(xlUp).Row. I reference this variable multiple times in the same Sub across different worksheets but it only works the first time on the first worksheet. I've found that redefining the LastRow before the second reference works but I'm wondering how I could change the code such that I don't need to define it twice in the same Sub.
The method you are using to find the last row relies on the length of column A. Another way to define the last row, regardless of which column is the longes is:
The lstRw variable will have to be re-initialized if you add or delete rows or clear contents of the original last row, any of which would then physically change which row has the last vertical data entry. The variable is not dynamic and will not change automatically when you change the sheet content. You can find several articles on 'last row variable' by web search which go into greater detail about using a varible to definge the row you want to use.
Please Login or Register to view this content.
Last edited by JLGWhiz; 12-22-2019 at 02:08 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks