Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this will also work for selecting range
Sub scrollToTheTopOfSheet() Dim ws As Worksheet Application.ScreenUpdating = False For Each ws In ThisWorkbook.Worksheets With ws .Activate .Range("A3").Activate End With With ActiveWindow .View = xlNormalView .ScrollRow = 1 .Zoom = 100 End With Next Application.ScreenUpdating = True End Sub "ordnance1" wrote: I run the code below to ensure that all worksheets are set to a 100% zoom and that cell A3 is selected on all worksheets. Is ther also a way to ensure that all worksheets are scrolled all of the way to the top? Sheets(Array("January", "February", "March", "April", "May", "June", "July", "August", _ "September", "October", "November", "December")).Select Sheets("January").Activate Range("A3").Select ActiveWindow.Zoom = 100 Sheets("January").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return to starting point | Excel Programming | |||
Return to starting point | Excel Programming | |||
Go back to starting point | Excel Programming | |||
bar chart starting point | Charts and Charting in Excel | |||
Starting Point of macro | Excel Programming |