Excel get cell value formula wont work.


Theres a problem with getting cell value when its a formula.
It works fine when theres plain text but wont work with my formula.

My formula: =MAX((AA:AA<>"")*(ROW(AA:AA)))+1 and this formula returns “150”

Is there a work around without opening excel on the screen and using keystrokes?

I want to get the last row in a column but when i use the Get column and check the size of it, it dosnt give the right results.