This should be easy but I can not get the following to work.
I'm entering a formula into a cell using a variable in the formula. What I need to do is insert a formula that gives the average of C2 to N , where N is an entry the user puts in. Soooo, the formula that gets posted into F1 is: Range("F1").Formula = "=Average("$C$3" ":" "$C,$N" )" I am fairly new to Excel VBA. Thanks!!