Using macro to enter relative reference formula
Using macro to enter relative reference formula
Running the following macro
ActiveCell.FormulaR1C1="=RC[-5]*RC[-2]"
in cell G17 results in #UNKNOWN error with cell contents
=B17*RC[-2]
i.e., Zoho is correctly translating the first relative reference but is treating the second relative reference literally.