Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
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 -- Regards Ron de Bruin http://www.rondebruin.nl "Steve" wrote in message ... 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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
.... 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 "Tom Ogilvy" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the name of column heads from A,B, C etc to something else
"Tom Ogilvy" wrote in
: 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)? -- Poseur "That's just kooky talk." --Kramer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Column Heads WITHOUT Excel Column Lables | Excel Worksheet Functions | |||
column heads | New Users to Excel | |||
Column Heads? | Excel Programming | |||
heads of column (listbox in UF) | Excel Programming | |||
Column heads for list box - how to do it | Excel Programming |