A1 style recording with Excel 2000 (win 2000)
 

Hi,

Is it really true that I can no longer record macros in the "A1-Style"
with Excel 2000?

I have tried everything possible I can imagine and nothin seems to
help, I always get 'FormulaR1C1' into my recorded codes...

I used to use Excel -97 and that still recorded formulas in the
A1-Style, which I would still love to use.

All the help would be highly appreciated.

A1 style recording with Excel 2000 (win 2000)
 

Yes Excel still supports the A1 style references. Just drop the R1C1 from
Formula:
Range("F13").Formula = "=IF(E13<50,0,E13^2)"

Mike F
"Jo Ku" wrote in message
om...
Hi,

Is it really true that I can no longer record macros in the "A1-Style"
with Excel 2000?

I have tried everything possible I can imagine and nothin seems to
help, I always get 'FormulaR1C1' into my recorded codes...

I used to use Excel -97 and that still recorded formulas in the
A1-Style, which I would still love to use.

All the help would be highly appreciated.

A1 style recording with Excel 2000 (win 2000)
 

Sorry, I misread your intent- No Excel will no longer record A1 style
formulas, but they can be written in A1 style. It's a pain, but you can copy
the formula from the cell and paste it into the macro using the example
format from the earlier post.

Mike F
"Jo Ku" wrote in message
om...
Hi,

Is it really true that I can no longer record macros in the "A1-Style"
with Excel 2000?

I have tried everything possible I can imagine and nothin seems to
help, I always get 'FormulaR1C1' into my recorded codes...

I used to use Excel -97 and that still recorded formulas in the
A1-Style, which I would still love to use.

All the help would be highly appreciated.