FormulaArray when inserting a formula

[sriley5]

Hi,

I have an array formula that I am trying to input in a range, however, I get an error message stating "Unable to set the FormulaArray Property of the Range Class. Any help would be greatly appreciated.

Please Login or Register  to view this content.

[romperstomper]

You have one too many closing brackets at the end of the formula.

[sriley5]

Got it, Thank you, but now it wont calculate with the correct values, when I go to the formula and try to run it again, I get an error message that states I cannot change part of an array

[romperstomper]

Your code is the equivalent of selecting all those cells in column C, typing the formula and then pressing Ctrl+Shift+Enter, which isn't what you actually want. You need to enter it into one cell, then fill it down like this (untested):

Please Login or Register  to view this content.

[sriley5]

This is awesome, Thank you for explaining the difference.

[romperstomper]

Glad to help - thanks for the rep.