View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ramzi ramzi is offline
external usenet poster
 
Posts: 24
Default using macro to copy paste

Thank you Stefi...

"Stefi" wrote:

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