I am trying to find the highest row that is visible on my screen. It boils down to needing the highest row from a range that is visible or else it will just return my frozen title row. (INFO("origin") will do that.)
I have tried rng.SpecialCells(xlCellTypeVisible).Row but that doesn't do the trick.
I do recall there are a number of undocumented functions that I have seen here in the past but I don't remember what they are and you've got to know what you're searching for in order to do a search!
Can someone point me in the right direction please?
Bookmarks