macro to copy a range from 1 sheet and paste

November 7, 2011 at 04:03:06
Specs: Windows XP
I have a 2 sheet spreadsheet. In sheet "data" I have a range "allp". I need a macro that will copy and delete range "allp" then select sheet "test" and paste the copied values with the 1st value into cell B1 of that sheet. Any help would be greatly appreciated.
Thanks
John

See More: macro to copy a range from 1 sheet and paste

Report •

#1
November 7, 2011 at 10:18:43
Sub CutPaste()
  Sheets("data").Range("allp").Cut _
     Destination:=Sheets("test").Range("B1")
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question