Copy row from one workbook to another

C

C Holmes

Hello,

I need to copy rows 1 - 4 from one workbook to another workbook. I wouldn't
think it would be that difficult, but I can't figure it out. Appreciate any
help. I'm using Excel 2003.

Thanks.
 
E

Eduardo

Hi,
try
Sub Macro1()
'
' Macro1 Macro
'

'
Sheets("Sheet2").Select
Rows("1:4").Select
Selection.Copy
Sheets("Sheet1").Select
ActiveSheet.Paste
End Sub
 
J

JLGWhiz

You can do that manually by selecting the range to copy, then Edit>Copy
---Activate the other workbook, select the anchor cell, then Edit>Paste.

For VBA:

Sub cpyRw1_4()
Set wb1 = ActiveWorkbook.ActiveSheet
Set wb2 = Workbooks(2).Sheets(1)
wb1.Rows("1:4").Copy wb2.Range("A1")
End Sub




Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Protection 2
Copy Multiple Areas from One Workbook to Another 4
Scattered array cells copy to scattered array cells another workbook 14
Import multiple workbooks to current workbook in specified row number 0
Pulling data from one workbook to another one using VBA 0
Copy Active Range from one workbook to another 1
How to append data from different sheet and different workbook? 2

Top