Hi Steve

You can use window -Freeze Panes in the menubar
to freeze the first column and Row.
Select cell b2 and do window -Freeze Panes

You can put your own headers in the first row and column then

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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