VBA:如何在range中使用变量作为参数？

Sub UseRangeWithVariables()
    Dim startCell As String
    Dim endCell As String
    Dim rng As Range

    ' 定义起始单元格和结束单元格
    startCell = "A1"
    endCell = "B10"

    ' 使用变量定义范围
    Set rng = Range(startCell & ":" & endCell)

    ' 对范围进行操作，例如填充颜色
    rng.Interior.Color = RGB(255, 255, 0) ' 黄色
End Sub

Sub UseRangeWithRowColVariables()
    Dim startRow As Integer
    Dim startCol As Integer
    Dim endRow As Integer
    Dim endCol As Integer
    Dim rng As Range

    ' 定义起始行、起始列和结束行、结束列
    startRow = 1
    startCol = 1
    endRow = 10
    endCol = 2

    ' 使用变量定义范围
    Set rng = Range(Cells(startRow, startCol), Cells(endRow, endCol))

    ' 对范围进行操作，例如填充颜色
    rng.Interior.Color = RGB(0, 255, 0) ' 绿色
End Sub

Sub UseNamedRangeWithVariable()
    Dim rangeName As String
    Dim rng As Range

    ' 定义命名范围的名称
    rangeName = "MyNamedRange"

    ' 使用变量引用命名范围
    Set rng = Range(rangeName)

    ' 对范围进行操作，例如填充颜色
    rng.Interior.Color = RGB(0, 0, 255) ' 蓝色
End Sub