VBA copy x rows to new workbook

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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,131
Messages
5,527,021
Members
409,736
Latest member
maanbunty

This Week's Hot Topics

Top