hiko-blog https://blog.hatena.ne.jp/hiko-blog/ Hiko.Blog Excel VBA活用術 https://hiko-blog.hatenadiary.com/ VBA Sub Worksheet_Activate() Dim wbThis As Workbook Dim wsThis As Worksheet Dim ws As Worksheet Dim ListStr As String '変数にこのブックをセット Set wbThis = ThisWorkbook '変数にこのシートをセット Set wsThis = wbThis.Worksheets("csv") 'リスト入力用変数に空文字を代入 ListStr = "" 'このシートと名前が違うシートをリストに追加 For Each ws In wbThis.Worksheets If ws.Na… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhiko-blog.hatenadiary.com%2Fentry%2F2024%2F01%2F19%2F071159" title="シート名取得 - Hiko.Blog Excel VBA活用術" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2024-01-19 07:11:59 rich https://hiko-blog.hatenadiary.com/entry/2024/01/19/071159 1.0 100%