K
KR
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
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