在VBA中，您可以使用以下方法引用變量作為Range的參數：
Dim rng As Range
Set rng = Range("A1:" & myVariable)
Dim rng As Range
Dim rngAddress As String
rngAddress = "A1:" & myVariable
Set rng = Range(rngAddress)
Dim rng As Range
Dim rowNum As Integer
Dim colNum As Integer
rowNum = 1
colNum = myVariable
Set rng = Cells(rowNum, colNum)
請根據您的具體情況選擇適合的方法來引用變量作為Range的參數。
