VBA FormulaArray Reference not converting from R1C1 to A1

I have a very large array formula (I consolidated many calculations into one) that I need to apply by VBA, however it is not converting one of the references from R1C1 to A1 (although other instances of these references are converting correctly).

My code is below.
All instances of RC9 convert to $I2, except the one in the following line of text:

Please Login or Register  to view this content.

When I stop the code before turning the reference style back to A1, I can see that the RC9 reference in the line above is entered in the formula as R[7]C[458]. The rest of the RC9 references have been entered in correctly as: RC9.
When the reference style is changed back to A1, all the RC9 references convert to: $I2, but the R[7]C[458] reference displays as: RC9.

I would greatly appreciate any troubleshooting ideas anyone might have to get this reference to convert correctly. Thank you.

Please Login or Register  to view this content.

Thanks for that, I recorded the macro which automatically put the formula in R1C1 format. There were other issues also including trying to apply an array formula to a table.
To get around it all, I changed the formula to A1 format and converted the data to a table after applying the formulas.