如何在vba中写带变量的范围

Dim rng As Range
Dim startCell As Range
Dim endCell As Range

Set startCell = Range("A1")
Set endCell = Range("B5")
Set rng = Range(startCell, endCell)

Dim rng As Range
Dim startRow As Integer
Dim startColumn As Integer
Dim endRow As Integer
Dim endColumn As Integer

startRow = 1
startColumn = 1
endRow = 5
endColumn = 2
Set rng = Range(Cells(startRow, startColumn), Cells(endRow, endColumn))

Dim rng As Range
Dim startCell As Range
Dim offsetRows As Integer
Dim offsetColumns As Integer

Set startCell = Range("A1")
offsetRows = 5
offsetColumns = 2
Set rng = startCell.Offset(offsetRows, offsetColumns)