cells as range

[steve_bris]

Hi

Could someone please help me with the syntax of specifying a range throught the use of excel cells... with access vba

for example, something like this.

Range(cells(2, 4) & ":" & cells (10, 10)).select

I want to do this so that I can add intergers to teh Column number and move the range around .

Tyanks for any help

Steve

 

[steve_bris]

Unfortunatly I still get an error....

I am using

Range(Cells(TableRow, 2), Cells(TableRow + 2, DATENo + 2)).Select


Where DATENo =3 and TableRow = 27 and are both integers......the variable names will vary throught the code and I have to be able to resize the selection by adding an integer to the start column (2)

Thanks for any help

Steve