Thread: [Solved] Go to second last blank row
View Single Post
 
Old 05-14-2020, 05:40 PM
Dave T Dave T is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default

Hello Logit,

I have attached a workbook with some dummy data and a few macros I currently use.
Column E contains some dummy formulas and conditional formatting.

As I progressively fill column A with data, I would see my column end markers and be aware of that I would need to copy more rows.

I have left a few blank cells in column A as an example.
What I meant by second last row in my workbook would mean that cell A27 would be selected (or whatever the second last cell is).

Regards, Dave T
Attached Files
File Type: xlsm Find Second Last Blank Cell.xlsm (21.5 KB, 11 views)
Reply With Quote