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,