SumIf WorksheetFunction referencing another workbook

Dear all,

I'm trying to use the SumIf worksheetfunction in VBA, looking in another workbook, but I apparently use the wrong reference. It works without any problem in Excel. I receive the following pop up message : "method range of object worksheet failed"

Here is my code :

Please Login or Register  to view this content.

I understand that to be proper, I should use workbooks(File).worksheets("Budget 2013").range("Q5:Q52"), but I'm afraid that my code will be too long, because I'd like to use many conditions (with SumIfs)...
I already tried many attempts without any success, would you have any idea about my mistake?

Many thanks in advance for your lights.

Best regards,

Eric

Thanks Sixthsense, but do you know why I have this error message? Because I will probably use SumProduct function to work with closed book and I will probably face the same problem, don't you thinks so?

Eric

You may not refer to a Range object in VBA in a workbook that is closed.

Originally Posted by Izandol

You may not refer to a Range object in VBA in a workbook that is closed.

Noted Izandol, thanks.