Thank you in advance for any help.

I wrote the following code:

Worksheets(1).Select
ActiveCell.Offset(0, -4).Copy
Worksheets(3).Select
ActiveCell.Offset(1, -1).PasteSpecial

Is there any way I could simplify this down to two lines?
I am using Excel 2000. Thanks.

Mike

For example activecell cell is column E and row is row 1, and you want to
copy the content of A1 Sheet1, and paste it to Sheet3 A1:
Sheets(1).Cells(1, 1).Copy Destination:=Sheets(3).Cells(1, 1)
Actually just one line.

Swisse