simple EXCEL VBA QUESTION

2009-02-04 2:06 am

我想選擇一個範圍, a1:c10 , 下面個vba code 有問題, 應該點改??

Sub testing()

Dim num As Integer

num = 10

Range("a1:c&num").Select

End Sub

回答 (1)

2009-02-04 5:06 am

✔ 最佳答案

Sub testing()

Dim num As Integer

num = 10

Range("a1:c" & num).Select

End Sub

Calvin Lee, [email protected]

👍 0 👎 0