Error Using WorksheetFunction.SumIf

I have some Code that does a number of things but currently I am looking to get the value of a SumIf into a cell on my worksheet. My Data is on the 'CheckerSheet' and the criteria I am matching is on the 'DiscrepancySheet'. The sheets are in separate workbooks and both workbooks are open.

Please Login or Register  to view this content.

I am getting a 1004 error Method 'Range' of Object '_Worksheet' failed. Debugging points me to the first line of the For statement. Replacing '.Cells(i, 2)' with a string that matches one of the options gets it to work so I know the problem is there but I cant seem to figure it out. I have tried the following options

Please Login or Register  to view this content.

I know this probably going to be a simple fix and I am going to feel like an idiot but it's stumping me right now.

Thanks in advance for the assist!!

Try this...

WorksheetFunction.SumIf(Range(CheckerSheet.Cells(7, 3), CheckerSheet.Cells(CheckerMaxRow, 3)), ...

Worked like a charm. Thank you both so much.

I confused myself by getting it to work with the static value in there but in copying the static value I was leaving the 'CheckerSheet' active and avoiding the Range error.