I am using the line of code below to enter a formula to remove the "]" character from a column. The formula below will work when entered manually, but when I run the macro, I get an error message.
Range("H2:H" & FinalRow).FormulaR1C1 = "=SUBSTITUTE(RIGHT(RC[-1],7),CHAR(93),"")"
Error...