温馨提示×

vba里range怎么引用变量

vba

小亿

1291

2023-09-05 20:58:27

栏目: 编程语言

开发者测试专用服务器限时活动，0元免费领，库存有限，领完即止！点击查看>>

在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的参数。

1 赞

0 踩

最新问答