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.