Unable to set the FormulaArray properties of the Range Class

[Bob Phillips]

I am trying to get rid of the B2 and replace it with rAcctNo and get rid of G2 and replace it with rCalcDate and replace 10 with Comments. I don't want the hard coded B2 and G2 and 10.

While these will work for now, if the input sheets that the data come from have the columns "Acct No", "Calculated Date" and "Comments" move, then my code is broken at that point.

You should name those cells and use the name in the code.