find first visible row in excel frozen pane

[dlebelsr@comcast.net]

I need to set a range beginning with data in the first visible row beneath a frozen pane.
This range would need to change as I scroll down the list.

Is there anyway to do this?
Thanks

[ryan4646]

ur example file will help to realize and get you answered accurately and immediately.

[Andy Pope]

Please Login or Register  to view this content.

Will give you the cell in top left corner of movable section below frozen pane(s).

[dlebelsr@comcast.net]

thank you, sir