using macro to copy paste

  • Thread starter Thread starter ramzi
  • Start date Start date
R

ramzi

hi....

I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4
at sheet 2 without open sheet 2.
Can anyone help me on this..

rgds
 
Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1")

Regards,
Stefi

„ramzi†ezt írta:
 
You are welcome! Thanks for the feedback!
Stefi

„ramzi†ezt írta:
 
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
Copying data to the next blank row 0
Copy a formula using Vlookup 2
Filtering of data in a master excel sheet from multiple sheets 3
Help!!!!!! 2
Go to next cell if full 2
How to update data from multiple sheets to one specific sheets 4
SUM of Changing source value, pls help!!! 8

Back
Top