dynamic named range horizontal

[daveyc18]

so I have a name ranged covering months from column C to AB ...however ...I will be often adding new months (eg column AC, ad)

instead of manually changing the range each time, is there a way to make this dynamic ??

 

[Eric W]

Do you have the month in row 1? Is it a text value, or a date value (numeric)? Does your range include just the column header, or do you want to include some rows below it?