View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anders[_2_] Anders[_2_] is offline
external usenet poster
 
Posts: 8
Default Macro: Copy data to another sheet

Per Jessen skrev:
Hi Anders

M38:O49 = 12 rows
AB3:AD12=10 rows only


Sorry, my mistake. Wrote the wrong numbers :-)

Sub AddMatrix()
Sheets("Sheet1").Range("M38:O49").Copy
Sheets("Sheet2").Range("AB3").PasteSpecial Operation:=xlAdd
End Sub


Works like a charm!

Thank you.

Anders