2019-08-09から1日間の記事一覧

VBA for OpenSelectionFile

Option Explicit Sub 行非表示() 'Rows.RowHeight = 18.75 Dim va As Variant, ro As Range Dim words As Variant words = Array("aa", "ab") For Each va In words Set ro = Cells.Find(va, , , xlWhole, xlByColumns).EntireRow ro.Hidden = True Next End…