Range(Cells(20, 7), Cells(20, 23)). Copy error

[capt_74_2000]

What's wrong with this statement? I need to be able to copy and paste a range that is variable i.e. (C7:C12 this time, and perhaps Q7:Q13 the next time. The following statement looks to be "in the ball park", but it returns an error (Run-time error '1004': Application-defined or object-defined error).
The statement with hard coded row/cols follows:
Worksheets("Sheet1").Range(Cells(20, 7), Cells(20, 23)).Copy

Thanks
_Mike

[RET79]

On 2002-05-08 12:12, capt_74_2000 wrote:
What's wrong with this statement? I need to be able to copy and paste a range that is variable i.e. (C7:C12 this time, and perhaps Q7:Q13 the next time. The following statement looks to be "in the ball park", but it returns an error (Run-time error '1004': Application-defined or object-defined error).
The statement with hard coded row/cols follows:
Worksheets("Sheet1").Range(Cells(20, 7), Cells(20, 23)).Copy

Thanks
_Mike

Instead try

With Worksheets("Sheet1")
.Range(.Cells(20, 7), .Cells(20, 23)).Copy
End with

Hope that works,

RET79