Hello,
How can I select the last row before blank rows but exclude a column, for example column A?
Hello,
How can I select the last row before blank rows but exclude a column, for example column A?
Assuming there is data in column A try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
the problem is, the column A contains a function, which numbers each row as the cell next to it is filled and this code selects the last row that has the function.
You can choose another column to get the last row, one that doesn't have formulas copied down below the data.
The below code uses B but you can change that to whatever column is appropriate.
Please Login or Register to view this content.
Or maybe something like this ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
after changing the function in column A it keeps selecting the empty row after the row that is filled.
this function is in column A
Please Login or Register to view this content.
@(T_T), if you're referring to my code & you want last row with data & not blank, change the below in my code
Please Login or Register to view this content.
thank you both
Glad to help & thanks for the added Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks