Lock array formula in cell

[Jerseynjphillypa]

I am trying to lock the array formula in the cell AG1 with the formula

{=Stdev(IF(State=""NJ"",Qty="""",Qty))}

But with my code below in a Macro, when I click on the cell it removes the {} around the formula so the function doesn't work anymore

Please Login or Register  to view this content.

[daddylonglegs]

It may be because the formula syntax is incorrect, can you describe in words what you are trying to do with the formula, it looks like you want STDEV of QTY values when State is "NJ" and QTY is blank, but that doesn't make sense, should it be when Qty is not blank? For that try

Please Login or Register  to view this content.