VBA copy x rows to new workbook

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

rassten

Active Member
Joined
Aug 31, 2008
Messages
310
Maybe this can help:
Code:
Sub b_test()
Range("a1:b50").Copy Destination:=Workbooks("50.xls").Sheets("Sheet1").Range("b2")
End Sub
But workbook 50.xls has to be open.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,508
Messages
5,529,272
Members
409,859
Latest member
emperorgenghiskhan
Top