How to change columns Titles

MrBlue · Apr 7th, 2002, 02:40 PM

I'm a Newbie in VB and I have some difficulties to make a simple macro (I think).
My macro should change the titles ( in A->" Date" , B->"Salary", .... )of the columns ( or rows ) in order to screen them even if i'm editing the thousandths row ( or column ).
Thank you for your help.

Anne Troy · Apr 7th, 2002, 04:28 PM

So are you saying that you want VB code that will fill in or change your column headings?

Or are you trying to get VB code to *capture* the column headings that are already there.

I'm sorry, it's not clear to me exactly what you are after. If you have some code that doesn't work quite right for you, please paste it for the coders to see.

Thanks!

MrBlue · Apr 8th, 2002, 01:01 PM

I was thinking to use VB to change the *Headings* of the columns but by seeing your answer it seems to have a simpliest solution...
Sorry but as I was telling in my first topic I'm a newbie in VB. I would have had to specify : in excel too !

Apr 7th, 2002, 04:28 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,535	So are you saying that you want VB code that will fill in or change your column headings? Or are you trying to get VB code to capture the column headings that are already there. I'm sorry, it's not clear to me exactly what you are after. If you have some code that doesn't work quite right for you, please paste it for the coders to see. Thanks! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 7th, 2002, 02:40 PM	#1
MrBlue New Member Join Date: Apr 2002 Posts: 2	I'm a Newbie in VB and I have some difficulties to make a simple macro (I think). My macro should change the titles ( in A->" Date" , B->"Salary", .... )of the columns ( or rows ) in order to screen them even if i'm editing the thousandths row ( or column ). Thank you for your help.

Apr 8th, 2002, 01:01 PM	#3
MrBlue New Member Join Date: Apr 2002 Posts: 2	I was thinking to use VB to change the Headings of the columns but by seeing your answer it seems to have a simpliest solution... Sorry but as I was telling in my first topic I'm a newbie in VB. I would have had to specify : in excel too !