Copy and Paste Macro - Simplifying

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Copy & paste special 2
Can Vba workout if a selection is part of a group? 0
Copy and paste 1
Creating a macro 3
Macro: Code for skip a row 5
Help me4 2
Configure macro to run on all sheets Excel 2k7 9

Back
Top