0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

Excel VBA 自动选择所有表的A1单元格

Posted at

将Excel内部所有表的格子选择在A1单元格,增加美观度

Sub SetSelectA1()
    Dim wss As Worksheet
    
    For Each wss In ThisWorkbook.Worksheets
        wss.Activate
        wss.Cells(1, 1).Select
    Next wss
    '最初のシートを選択する(最初に戻す)
    Worksheets(1).Activate
End Sub
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?