Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaArray alternative for A1 reference style?
I've always used A1 reference style in all my code, formulas, etc. I guess
my brain is just wrapped that way. Now I need to use VBA code to insert an array formula, because the source ranges are changed when new data are added, and I need to reset the array formula to the original ranges again. however, my A1 notation doesn't play well with FormulaArray. Is there an alternative? Or, if I use R1C1 notation for just this formula, will that affect anything else in the workbook? Should I set my array formulas to use named ranges instead of straight worksheet references, and use VBA to refresh the named ranges instead? Thanks! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Worksheet Functions | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
Range.FormulaArray drops relative reference ? | Excel Programming |