セル・セル範囲の選択
セルの選択
Range("A1").Select
Cells(1, 1).Select
連続セル範囲の選択
Range("A1:A10").Select
Range(Cells(1, 1), Cells(10, 1)).Select
非連続セル範囲の選択
Range("A1:A10,C1:C10").Select
Range(Cells(1, 1), Cells(10, 1)).Name = "aa"
Range(Cells(1, 3), Cells(10, 3)).Name = "bb"
Range("aa,bb").Select
Dim cl(2) As String
cl(1) = Range(Cells(1, 1), Cells(10, 1)).Address
cl(2) = Range(Cells(1, 3), Cells(10, 3)).Address
Range(cl(1) & "," & cl(2)).Select
Range("A1").Select
Cells(1, 1).Select
連続セル範囲の選択
Range("A1:A10").Select
Range(Cells(1, 1), Cells(10, 1)).Select
非連続セル範囲の選択
Range("A1:A10,C1:C10").Select
Range(Cells(1, 1), Cells(10, 1)).Name = "aa"
Range(Cells(1, 3), Cells(10, 3)).Name = "bb"
Range("aa,bb").Select
Dim cl(2) As String
cl(1) = Range(Cells(1, 1), Cells(10, 1)).Address
cl(2) = Range(Cells(1, 3), Cells(10, 3)).Address
Range(cl(1) & "," & cl(2)).Select
by yuna-tip
| 2002-08-01 10:24
| セルの操作