Find the last row with data in it in a row of formulas?

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,351
Hi Everyone,

I have a small range of BJ28:BJ42
I want to find the lastrow that contains data,
they all contain formulas so my normal lastrow method select every row,
but the formulas have "(IF a21 = "","")" for example so some cell go "", I want the last row that has a value in it.

Please help if you can

Thanks

Tony
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
6,910
Office Version
2019
Platform
Windows
Are you trying to do this with vba or with a formula?

Is the data text, numeric or a mixture of both?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
How about
Code:
Range("BJ28:BJ" & Rows.Count).Find("*", , xlValues, , xlByRows, xlPrevious, , , False).Row
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,078,242
Messages
5,339,042
Members
399,275
Latest member
amrita17170909

Some videos you may like

This Week's Hot Topics

Top