On Sat, 14 Oct 2006 12:50:48 -0500, Dave Peterson
wrote:

I know that if you mix A1 references style with R1C1 reference style, things
blow up quickly:

ActiveCell.Formula = "=sum(R1C1:R10C1)+B1"

My uninformed guess is that when you enter a formula in excel, excel "sees" it
as R1C1 no matter what your settings are showing. And then it converts the
formula to A1 reference style to show it to the user (if it has to).

I found this interesting.

Try this. Start a new workbook with two sheets.

Change excel to use A1 reference style
Format Cell A1 in Sheet1 as General
Format Cell A1 in Sheet2 as Text
Group these two sheets
With Sheet1 the activesheet
type this in A1
=B1+C1

Now look at the formula entered in A1 of Sheet2.

Kind of interesting, huh?


Verry interesting.

I suppose the A1 notation style was adopted to differentiate it from Lotus.
--ron