Make upper left of sheets visible

[AD108]

After my code is done running, I need to get the top left part of each sheet
in the book to be visible. What would be the best approach to accomplish
this.

Thanks

[ChasAA]

Range("A1").select ??


"AD108" wrote:

> After my code is done running, I need to get the top left part of each sheet
> in the book to be visible. What would be the best approach to accomplish
> this.
>
> Thanks
>
>
>

[NickHK]

Application.Goto Range("A1"), True

NickHK

"AD108" <arielNOSPAM@downtoearth.org> wrote in message
news:eI%23GEu6sGHA.372@TK2MSFTNGP06.phx.gbl...
> After my code is done running, I need to get the top left part of each
sheet
> in the book to be visible. What would be the best approach to accomplish
> this.
>
> Thanks
>
>

[Joerg]

"AD108" <arielNOSPAM@downtoearth.org> wrote in message
news:eI%23GEu6sGHA.372@TK2MSFTNGP06.phx.gbl...
> After my code is done running, I need to get the top left part of each
sheet
> in the book to be visible. What would be the best approach to accomplish
> this.
>
> Thanks
>

Try
ActiveWindow.ScrollIntoView 0, 0, 0, 0

Cheers
Joerg