View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Copy row from one workbook to another

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

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


"C Holmes" wrote:

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.