Running below code get formula of =SUM('b9':B26)
Is there anyone tell me how can I get rid of '' from b9 by amend the below
coding?

ActiveCell.FormulaR1C1 = "=SUM(b9:R[-1]C)"