Ignore "if" formula for Lastrow function

[bsrivatsa]

Hi all,

I am using the Lastrow function to define my range, but this is resulting in blank cells containing "if" formulae to be counted too. I want the last row to be the one where the "if" formula has resulted in a value ( in my case the column has dates in mm/dd/yy format) and ignore the rows below where the formula returns a blank ("") value.
Any suggestions?

Thanks

[Richard Buttrey]

One way to find the last non blank row is

Please Login or Register  to view this content.

[Brian Itotia]

at first glance, maybe check the value of the variable with the isdate function.

[bsrivatsa]

Essentially, need to alter this definition of LastRow to ignore rows where formula has resulted in "" values-
LastRow = ActiveSheet.Range("AD" & Rows.Count).End(xlUp).Row

Sorry, couldn't adopt the solutions suggested by Brian and Richard, due to my limited understanding of how VBA works.

[Brian Itotia]

hi there

can you post the code youre working with by any chance?

[Fluff13]

Maybe something like

Please Login or Register  to view this content.

[Richard Buttrey]

Essentially, need to alter this definition of LastRow to ignore rows where formula has resulted in "" values-
LastRow = ActiveSheet.Range("AD" & Rows.Count).End(xlUp).Row

Sorry, couldn't adopt the solutions suggested by Brian and Richard, due to my limited understanding of how VBA works.

My suggested function does not involve VBA

See the attached example. A2:A20 contain dates which only show if the adjacent column B contains a 1.

If you need to use it in VBA then just read it in from the Excel cell that holds the value.