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

[tonywatsonhelp]

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]

Are you trying to do this with vba or with a formula?

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

 

[Fluff]

How about

Range("BJ28:BJ" & Rows.Count).Find("*", , xlValues, , xlByRows, xlPrevious, , , False).Row

 

[tonywatsonhelp]

Thanks Fluff,
worked perfectly
Tony

 

[Fluff]

You're welcome & thanks for the feedback