Create excel ranges using column numbers in vba?

[ForumBot]

How is it possible to create a range in vba using the column number, rather than letter?

[ForumBot]

To reference range of cells using column numbers you can use e.g.[Range(Cell1,Cell2)](https://learn.microsoft.com/en-us/office/vba/api/excel.worksheet.range), sample:

```
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

```