Last value in a column H using VBA

[AC]

I can use MsgBox Cells(Rows.Count, 8).End(xlUp).Value to get the last value in column H.

But now I have formulas in column H, like this =(IF(OR(F35,G35>0), OFFSET(H35,-1,0)- F35+G35,"")) and the msgbox is showing blank because it is looking at the last cell in column H. I need some code to get the last VALUE from that column. So if I have the foumulas in H4:H100 but the last value is in H25, H26:H100 are showing "", I need what in in H25
Thanks

 

[Aladin Akyurek]

I can use MsgBox Cells(Rows.Count, 8).End(xlUp).Value to get the last value in column H.

But now I have formulas in column H, like this =(IF(OR(F35,G35>0), OFFSET(H35,-1,0)- F35+G35,"")) and the msgbox is showing blank because it is looking at the last cell in column H. I need some code to get the last VALUE from that column. So if I have the foumulas in H4:H100 but the last value is in H25, H26:H100 are showing "", I need what in in H25
Thanks

You could also invoke a formula to fetch the last numeric value from the range of interest:

=LOOKUP(9.99999999999999E+307,H4:H100)

 

[AC]

Aladin, thanks, I know about that using a formula but wanted to use it in some code to do something if that cell was less than 2500, thought it would be easy in VBA but maybe not, I will put that formula in a cell and have my code look at it for the number.
Thanks again

 

[Aladin Akyurek]

Aladin, thanks, I know about that using a formula but wanted to use it in some code to do something if that cell was less than 2500, thought it would be easy in VBA but maybe not, I will put that formula in a cell and have my code look at it for the number.
Thanks again

You are welcome. In fact, formulas and code should interact thru posted results cells or groups of cells. By the way, thanks for providing feedback.