On Fri, 13 Oct 2006 20:06:29 -0500, Dave Peterson
wrote:

.formular1c1 means that you (as a coder) will write the formula in R1C1
reference style.

Excel will use the tools|options|view to show it to the user in whatever style
is chosen.

The same thing can be used with .formula. If you create a formula in VBA using
.formula, then excel will show it to the user using that setting.

Hmm. That's different from how I'm reading the HELP file. But it wouldn't be
the first time. It's curious that when setting the range object, it doesn't
seem to matter -- what comes out depends on the worksheet setting.
--ron