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
|