| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Insert Changes the Formula
Because by using the .FormulaR1C1 property, you've told VBA that the
range references will be of R1C1 form, not A1 form. You can either use .Formula, or you can modify the ranges to R1C1 In article , Dow wrote: Why does it convert the range to F:(F)? And how can I fix it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Insert Changes the Formula
I knew it would be something obvious. I feel like an idiot now.
Thank you very much for your help. On Feb 6, 9:07*am, JE McGimpsey wrote: Because by using the .FormulaR1C1 property, you've told VBA that the range references will be of R1C1 form, not A1 form. You can either use .Formula, or you can modify the ranges to R1C1 In article , |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INsert Formula via Macro | Excel Programming | |||
| How do you insert a macro into a formula? | Excel Discussion (Misc queries) | |||
| Insert a Formula with a Macro | Excel Discussion (Misc queries) | |||
| Macro to insert formula | Excel Worksheet Functions | |||
| HOW DO YOU INSERT A MACRO INTO A FORMULA | Excel Worksheet Functions | |||
Hybrid Mode
