I'm trying to add a piece of formula to an existing formula but is not working. When I put a number into the strName variable it works

Asked Sep 16 '22 at 17:14

Active Sep 16 '22 at 17:46

Viewed 19 times

0

Dim strName As String
strName = "+2*SUMIF('Lvl 51,54'!C32:C180;$C42;'Lvl 51,54'!D32:D180)"


ActiveCell.Formula = ActiveCell.Formula + strName

edited Sep 16 '22 at 17:46

Scott Craner

148,073
10
49
81

asked Sep 16 '22 at 17:14

Javier Rodriguez

1

You need to use `.FormulaLocal` or change the formula separator to `,` from `;`. – BigBen Sep 16 '22 at 17:28
OMG thank you. That was the issue – Javier Rodriguez Sep 16 '22 at 17:44

0 Answers0