Currently, I have range C3:AJ3 named as "MyRange". A3 and B3 are being used as headers.
I'd like my named range in row 3 to dynamically expand when inserting new columns.
I've been working on this for a bit and I am stumped on what formula to use.
Thanks in advance for your help.
Bookmarks