VBA
Private properties As Collection ' プロパティコレクション' プロパティーに値を設定する。 Public Sub load(sht As Worksheet) Dim r As Range Dim c As Range Set properties = New Collection Set r = sht.Range(Range("A1"), Range("A60000").End(xlUp…
Workbooks.Open Filename:=フィイル & ".xls", ReadOnly:=True