I am receiving the #REF ! error in cells on a sheet generated when applying the following code into a vba sub.
When I view the formula in the sheet the #REF ! symbol is in the first R1C1 cell referenced (R[-23]C[-7]) and (R[-69]C[-7])
Range("L6").value = "dprice1" Range("L7").FormulaR1C1 =...