How would I make say Cell C1's value be "A1+B1",
rather than the caluculation of A1+B1 i.e. 4
Don't want the number 4 to show in the formula bar.
Because I'd like to autofill the formula and not the number 4 down the
column of a
similiar calculation.

I'd like to learn how to code something like that. Then I can apply it to
several different macros I have.

I want VBA to enter the formula into a cell rather than the resulting answer..
is this possible?