Is it possible to change the column heading names in a
macro ?

For example, I would like to rename column A to "Date" and
column B to "Surname"

If it is possible, would you please show me how to do it
and confirm whether or not this renaming might prove
problematic if I have to specify cell ranges within my
macro. i.e. if I refer to cell A will I have to refer to
it as "Date" from now on ?

Thank you in advance.

Steve