Thanks for that Ron, however, I am trying to work out how
to automate this task (using a macro). Any ideas?

Regards
Steve
-----Original Message-----
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


.