Dynamic selection of cells

[adashiu]

Hello

I have declared :

Dim i,j As Integer
i=5
j=7

How to make a selection of cells in rectangle i x j starting from A1 ?

[dominicb]

Good evening adashiu

How to make a selection of cells in rectangle i x j starting from A1 ?

Several different ways, but something like this, perhaps :

Sub test()
Dim i As Integer, j As Integer
i = 5
j = 7
Range(Cells(1, 1), Cells(i, j)).Select
End Sub

HTH

DominicB