A1:A10 是 excel 范圍的一般方式
我們可以將 A1 和 A10 存盤在變數中并像訪問它一樣訪問它嗎
num1 = A1
num2 = A10
num1:num2?
這在excel vba中可能嗎？
我試過這個但出現錯誤
Sub check()
Dim num1, num2 As Long
Dim rng As Range
num1 = Range("A1").Value
num2 = Range("A10").Value
Set rng = Range(num1 & ":" & num2)
Debug.Print (rng)
End Sub
uj5u.com熱心網友回復：
看起來這就是你所追求的？
Sub checkAsString()
Dim rng As Range
Dim num1 As String, num2 As String
num1 = "A1"
num2 = "A2"
strAddress = Trim(num1 & ":" & num2)
Set rng = Range(strAddress)
End Sub
或者，如果您真的想要使用編號范圍，那很可能是因為您想要使用整行或整列。在這種情況下，請參見下文：
Sub checkAsLong()
Dim rng As Range, address As Range
Dim str1 As String, str2 As String
Dim num1 As Long, num2 As Long
str1 = "A1"
str2 = "A2"
num1 = CLng(Range(str1).Value)
num2 = CLng(Range(str2).Value)
'assuming you want to select whole Rows...
Set rng = Range(Rows(num1), Rows(num2))
'assuming you want to select whole Columns...
Set rng = Range(Columns(num1), Columns(num2))
End Sub
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/533722.html
標籤：擅长VBA变量范围