Skip to content

Instantly share code, notes, and snippets.

@yoonchulkoh
Created September 13, 2011 00:45
Show Gist options
  • Save yoonchulkoh/1212875 to your computer and use it in GitHub Desktop.
Save yoonchulkoh/1212875 to your computer and use it in GitHub Desktop.
[VBA]全てのシートをA1に揃える
Sub 全てのシートをA1に揃える()
Dim s As Object
Dim defaultSheet As Object
Set defaultSheet = ActiveSheet
For Each s In ActiveWorkbook.Sheets
s.Activate
ActiveSheet.Range("A1").Select 'A1を選択
ActiveWindow.Zoom = 100 '倍率を100%に
Next s
Worksheets(1).Activate '最後に選択しておきたいシート
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment