Change the name of column heads from A,B, C etc to something else
It isn't possible. The best you could do is use row1 to simulate column
headings.
--
Regards,
Tom Ogilvy
"Steve" wrote in message
...
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
|