Syntax for dynamic range

[aviadht]

Hi,

Asume that i want to choose the following range:
Range("A18:O18").Select

But i want the cells to be dynamic

i know the column number as parameter "colnum1" and the last column as "Colnum2"
also i know the row number as integer "ronum"

Colnum1,colnum2,ronum are intergers

What is the syntax if i want to select the range of it ?

Thanks and Regards,
Aviad

 

[Sandeep Warrier]

Range("A" & RowNum1 & ":D" & RowNum2).Select

OR

Range(Cells(RowNum1,ColNum1), Cells(RowNum2,ColNum2)).Select


FYI... In most cases you don't need to select cells/ranges to perform actions on them