View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default using macro to copy paste

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

Regards,
Stefi

€˛ramzi€¯ ezt Ć*rta:

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