vasudev_kamat
New Member
- Joined
- May 7, 2012
- Messages
- 38
Hi Friends, I have a macro which is selecting range, below is the code. However my requirement is macro to copy full sheet instead of range and paste in another sheet. My data in range starting A2 to D9 in column. Row ending range keep changing. Please help.
Sub Copy_PasteSpecial_Method()
'Copy range to clipboard
Workbooks("New-Data.xlsx").Worksheets("Export").Range("A2:D9").Copy
'PasteSpecial to paste values, formulas, formats, etc.
Workbooks("Reports.xlsm").Worksheets("Data").Range("A2").PasteSpecial Paste:=xlPasteValues
End Sub
Regards
Vasudev
Sub Copy_PasteSpecial_Method()
'Copy range to clipboard
Workbooks("New-Data.xlsx").Worksheets("Export").Range("A2:D9").Copy
'PasteSpecial to paste values, formulas, formats, etc.
Workbooks("Reports.xlsm").Worksheets("Data").Range("A2").PasteSpecial Paste:=xlPasteValues
End Sub
Regards
Vasudev