A1 style recording with Excel 2000 (win 2000)

J

Jo Ku

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.
 
M

Mike Fogleman

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
 
M

Mike Fogleman

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
 
Top