I am having a problem with the following Macro:



Sub Combine()
Workbooks.Open Filename:="C:\Microsoft Office\Work\Excel\House
Expense.xlsx"
Range("C69:J85").Select
Selection.Copy
Workbooks.Open Filename:="C:\Microsoft Office\Work\Excel\Summary
House.xlsx"
Windows("combined.xlsx").Activate
Worksheets("Sheet1").Select
Range("C6").Select
ActiveSheet.Paste
End Sub

The lines dealing with opening a File name do not go to a second line

On the line: Windows("combined.xlsx").Activate

I receive an error: Run-time error '9': Subscript out of range.

I cannot figure this out.

Appreciate any help.

Thanks, Dave