View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default automatic copy and paste from sheet to sheet in a workbook

Hello,

Worksheets("Sheet1").Range("C15:C60").Copy _
Destination:=Worksheets("Sheet13").Range("C5:AZ5")

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!