hey i am just kind of getting back into VBA and i have a sheet into which i need to insert some formulas.
I know this is done with activecell.formulaR1C1 = Formula
however i am getting some weird things happening when i try to use FormulaR1C1 - can someone please point me to some documentation on how FormulaR1C1 works?
i looked in the help files and cant find anything.
I know this is done with activecell.formulaR1C1 = Formula
however i am getting some weird things happening when i try to use FormulaR1C1 - can someone please point me to some documentation on how FormulaR1C1 works?
i looked in the help files and cant find anything.