Find last Row in VBA ignoring formula blanks...

[Matty]

Hi,

I have a data set where I want to establish the last Row using Column A. For this, I would normally use:

LR = Range("A" & Rows.Count).End(xlUp).Row

However, the data set I am working on contains formula blanks ("") after the last "real" value, and this method is taking these Rows into account which I don't want.

Does anyone know an alternative method of doing this, where the formula blanks are ignored?

Thanks,

Matty

 

[pgc01]

Glad it helped.

 

[yaseensallam]

good thanks