Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 138
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make Excel 2007 chart sheets visible C. Varnavas Charts and Charting in Excel 1 April 25th 10 03:19 PM
fix left column(s) and/or upper row mariekek5 Excel Discussion (Misc queries) 6 June 24th 09 04:22 PM
Determine upper visible corner of sheet John Michl Excel Programming 2 May 4th 06 04:14 PM
How to change location A1 cell from upper right to upper left? Doug@Peacock Excel Discussion (Misc queries) 1 February 8th 05 02:37 PM
Code to make sheets in a workbook visible Jonsson[_4_] Excel Programming 5 January 30th 04 12:38 PM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"