I do not really understand the first 2 questions, but for the 3rdquation you can use "concatenate"So if you want to change 358 into variable, use this:FormulaR1C1 = "=RC[-5]/R[" & any variable & "]C[-5]"