Change the name of column heads from A,B, C etc to something else

[Steve]

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

 

[Ron de Bruin]

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

 

[Tom Ogilvy]

It isn't possible. The best you could do is use row1 to simulate column
headings.

 

[Steve]

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" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Any ideas?

The best thing you can do is to record a macro when you do this manual Steve.
You will get something like this then

Range("B2").Select
ActiveWindow.FreezePanes = True
ActiveWindow.DisplayHeadings = False

 

[Tim]

.... and then use Tools > Options > un-check row & column headings if you
want to remove

A B C D E
1
2
3

from the page (migth cause you trouble navigating your sheet though).

Regards,

Tim

 

[Poseur]

It isn't possible. The best you could do is use row1 to
simulate column headings.

What about just a named range (he said naively)?