HI all

I need to copy and paste a range of cells from one worksheet to
another. The first cell to be copied will always be A3. The last cell
will vary depending on how many rows of data are entered. The last
entry, however will always be in column S - only the row will vary.

I've tried a number of things, to no avail...can anyone help? Thanks.

I've monkeyed with this, too... got the solution by recording what I
would do on the sheet to make this happen...

This should work for you

Range("A3:S3").Select
Range(Selection, Selection.End(xlDown)).Select

Note: This will only work when the data in column A is continuous to
the end of the series (i.e., there are no blank cells between A3 and
the last cell in column A with data).

Hope that helps!

It does the job very nicely. Thanks!!!!!

If your data's not continuous but you are going to the last row in a column
you could use this to copy the range:

range(cells(3,1),cells(65536,19).end(xlup)).copy

Rob

" wrote:

I've monkeyed with this, too... got the solution by recording what I
would do on the sheet to make this happen...

This should work for you

Range("A3:S3").Select
Range(Selection, Selection.End(xlDown)).Select

Note: This will only work when the data in column A is continuous to
the end of the series (i.e., there are no blank cells between A3 and
the last cell in column A with data).

Hope that helps!