excel - 使用 vba 中的列号创建 Excel 范围？

Question

如何使用列号而不是字母在 vba 中创建范围？

Answer 1

要引用单元格范围，您可以使用 Range(Cell1,Cell2) ，样本:

Sub RangeTest()
  Dim testRange As Range
  Dim targetWorksheet As Worksheet
  
  Set targetWorksheet = Worksheets("MySheetName")
  
  With targetWorksheet
    .Cells(5, 10).Select 'selects cell J5 on targetWorksheet
    Set testRange = .Range(.Cells(5, 5), .Cells(10, 10))
  End With
  
  testRange.Select 'selects range of cells E5:J10 on targetWorksheet
  
End Sub