Returning worksheet "Home"

[hutch@edge.net]

S'up again, everybody?

This one is quick and easy. What line of code will return a worksheet to the "Home" position?

I have a worksheet with "Freeze Panes" activated. After my macro runs, the sheet is left down at the bottom, where the data was inserted. I want the sheet view to return to the top, where the chart is visible.

Usually I accomplish this at the end of the macro by simply adding
Range("A1").Select

That doesn't seem to work when you have the panes frozen.

End Goal: After the macro runs on each worksheet, I want the sheet to return to the top, with cell A1 selected.

Thanks, all.

Jerry

[rylo]

Jerry

Try

Please Login or Register  to view this content.

rylo

[hutch@edge.net]

Works perfectly, rylo. Thanks.