Dear All

First I wish you a happy new year 2019.

My problem:
I made macro which is relating to a thousand of lines and columns and this macro is quiet heavy (But very useful !).
In the following months I will have to add and remove columns without to affect my macro.
My problem is that rewrite all my formulas by changing old column names to new column names is to much time consuming.

My question :
Is it possible to give to a column a "given name" (i.e. "climbing") like a constant?
"Given names" of column would be given in respective cells along the first line of the sheet.

Then in the formula of my macro I could refer to the given name of a specific column (i.e. =SUM("climbing")) instead of initial column names (i.e."'=SUM(D:D)).

Therefore, my macro will not be affected by adding or removing column (Except if I give the same name to different columns)


Thanks for your answer.

Théo