Highest Row from Range that is Visible on Screen

[ffffloyd]

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?

[patel45]

Please Login or Register  to view this content.

[apo]

Hi..

I can't remember where i got this from.. but it works nicely..

Call the Function like this for example:

Please Login or Register  to view this content.

Note: Replace "YourSheet" with your sheet name where the autofilter is taking place..

Please Login or Register  to view this content.

[ffffloyd]

Thanks guys. It was really that simple.