Public Sub 全シートの左上セル選択()
On Error Resume Next
Application.ScreenUpdating = False
Dim i As Integer
For i = 1 To Worksheets.Count
Worksheets(i).Activate
Dim j As Integer
For j = 1 To Windows(1).Panes.Count
Windows(1).Panes(j).ScrollColumn = 1
Windows(1).Panes(j).ScrollRow = 1
Next
ActiveSheet.Cells(1, 1).Select
'ActiveWindow.View = xlNormalView
'ActiveWindow.Zoom = 100
Next
Worksheets(1).Activate
Application.ScreenUpdating = True
End Sub
Excel Book 全シートの左上セル選択
開発日誌(旧)
