Avatar of Bright01
Bright01
Flag for United States of America

asked on 

Leveraging Range Names in Excel Macros

EE Pros,
I will preface this as perhaps a strange question;
I often have a situation where I build a model that when I add a row or column, it screws up the Macro.  When I use range names rather than cell references in a macro, it generally works out much better.  With that said, how do quickly set up individual, non-contiguous cell references as range names (right now, this process is very laborious) and then now do I reference them in a Macro without listing each range name?
Thank you in advance,

B.
Microsoft Excel

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon