Error when trying to set worksheet

[frenchgreek]

I'm getting a "Subscript out of range" error when trying to set MonthlySells - why is that? The tabs exist in the workbooks so that can't be the reason.

Dim SCSAttribution As Workbook
Set SCSAttribution = Workbooks("SCS Attribution")

Dim AXATransactions As Workbook
Set AXATransactions = Workbooks("AXA Transactions Summary 08 05 2013")

Dim AssetReport As Worksheet
Set AssetReport = SCSAttribution.Worksheets("Asset Report")

Dim MonthlySells As Worksheet
Set MonthlySells = AXATransactions.Worksheets("Monthly Sells")

Dim MonthlyBuys As Worksheet
Set MonthlyBuys = AXATransactions.Worksheets("Monthly Buys")

 

[mikerickson]

The text of your question has "MothlySells", the code has "Monthly Sells".
Perhaps there is a space mismatch or a misspelling.