Inserting a SUMIFS formula using excel macro

[coop123]

Hello

I have a sumifs formula as part of a macro code.

ActiveCell.FormulaR1C1 = _
"=SUMIFS(M12:M" & ListEnd & ", $A12:$A" & ListEnd & ",""Non EU"",N12:N" & ListEnd & ",""<10"")" 'Non EU Less than 10%

Column M is the range to sum, column A is first criteria range and column N is second criteria. I am using ListEnd to give me last row in the columns. It is used throughout macro.


When running it stops with error Application-Defined or Object-Defined error.

Can someone point out where I have made the mistake.

Thanks in advance.

coop123

 

[Fluff]

You need to use Formula, not FormulaR1C1

 

[coop123]

Hi Fluff

Thank you for your solution.
It fixed my problem and macro now works.

Thanks Again

Coop123

 

[Fluff]

You're welcome & thanks for the feedback.