Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming |