Hi
Could someone please help me with the syntax of specifying a range throught the use of cells...
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
Re: specify a range
Hi Steve,
Like this:
Sub Test()
Dim rngTest As Range
Dim iCol As Integer
With ThisWorkbook.Worksheets("Sheet1")
For iCol = 5 To 10
Set rngTest = .Range(.Cells(2, 4), .Cells(10, iCol))
MsgBox rngTest.Address
Next iCol
End With
End SubHTH
Re: specify a range
Thanks Ritchie.
Is there a way of putting that into one line.....
I have tried
Worksheets("ROLE").Range(Cells(TableRow, 2), Cells(TableRow + 2, DATENo + 2)).Select
Worksheets("ROLE").Range(.Cells(TableRow, 2), .Cells(TableRow + 2, DATENo + 2)).Select
Range(Cells(TableRow, 2), Cells(TableRow + 2, DATENo + 2)).Select
and lots of other combinations.....hehe
TableRow and DATENo and integers from elsewhere in the code.
Don’t have an account yet? Register yourself now and be a part of our community!