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]


收錄日期: 2021-05-01 16:28:08
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090203000051KK01874

檢視 Wayback Machine 備份