Last cell with data in range

[berty2000]

Hi

Im trying to select the last cell with data in from a range H90:H108 but if the cells have formula in it and a result it misses that as last cell used.
I have tried

Range("H108").End(xlUp).Select

Im sure its simple but its nearly midnight and some times you can be staring at something too long.

 

[MARK858]

Maybe...
Last cell with Formulas giving a result

Range("H90:H108").Find("*", , xlValues, , xlByRows, xlPrevious).Select

Last cell with Formulas including those that return ""

Range("H90:H108").Find("*", , xlFormulas, , xlByRows, xlPrevious).Select

 

[berty2000]

That works fantastic Thanks Mark I just about to call it a night

 

[MARK858]

You're welcome