変数

変数宣言

' 変数を宣言
Dim variable

' 型を指定して変数を宣言
Dim variable As Int

' 複数の変数を宣言
Dim variable_01, variable_02

' 変数宣言と同時に初期化
Dim variableName As String: variableName = "value"

' 変数に値を設定
Dim variableName As String
variableName = "value"

' オブジェクト型の値を設定
Dim variableName As Workbook
Set variableName = Workbooks("BookName.xlsx")