using the range method

[mike]

i want to select certain columns and rows and use this
selection to create a chart. The selection is in a loop
and the cell locations will vary every time it is run.
Here's my code:

Worksheets(1).Range(Cells(startRow, 16), Cells(endRow,
18)).Select

where "startRow" and "endRow" are integers.

I always get the error that "Method 'Cells' of
object '_Global' failed" Am I using the wrong format for
the Range method?
thanks in advance

 

[Alan Beban]

or the much more efficient:

With Worksheets(1)
.Range(.Cells(startRow, 16), .Cells(endRow, 18)).Select
End With

One might also consider

Set rng = Worksheets(1).Range("A1")
Range(rng(startRow, 16), rng(endRow, 18)).Select

Alan Beban