Target last row of filter, get cell data

[Gil149]

I am trying to target the last row of a filtered range (using autofilter) and get the value in the "O"column. I have tried a few methods but I cannot seem to grab the cell value. Everything returns the row number. Using Excel 2003 and stumped!

 

[MrKowz]

Try:

Range("O" & Rows.Count).End(xlUp).Value

 

[Gil149]

MrKowz, thank you. I was trying to target with the .specialcell(xlcelltypevisible) because every other approach produced results from non filtered, yours worked!

 

[Aladin Akyurek]

I am trying to target the last row of a filtered range (using autofilter) and get the value in the "O"column. I have tried a few methods but I cannot seem to grab the cell value. Everything returns the row number. Using Excel 2003 and stumped!

If a numeric value expected...

Control+shift+enter, not just enter:

=LOOKUP(9.99999999999999E+307,IF(SUBTOTAL(3,OFFSET(O2:O100,ROW(O2:O100)-ROW(O2),,1)),O2:O100))

If a text value is expected...

Control+shift+enter, not just enter:

=LOOKUP(REPT("z",255),IF(SUBTOTAL(3,OFFSET(O2:O100,ROW(O2:O100)-ROW(O2),,1)),O2:O100))