ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Make upper left of sheets visible (https://www.excelbanter.com/excel-programming/368759-make-upper-left-sheets-visible.html)

AD108

Make upper left of sheets visible
 
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

Make upper left of sheets visible
 
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

Make upper left of sheets visible
 
Application.Goto Range("A1"), True

NickHK

"AD108" wrote in message
...
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

Make upper left of sheets visible
 

"AD108" wrote in message
...
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





All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com