Excel - Changing Columns and Rows name

[Rome75]

I'd like to know if it's possible to change columns and rows name in Excel using programming a VBA script???
So, i'd like to programmatically change columns name A, B, C in something always different..
thanks

 

[TonyJollans]

Hi Rome75,

Columns and Rows don't really have names. The row numbers and column letters are a convenient method of unambiguously referencing a position relative to the start of a worksheet but they are not names. You can name a range which is a single column or a single row, but that is not exactly the same as a row or column id because it will move if rows or columns are inserted or deleted before it.

Enjoy,
Tony

 

[xlbo]

You can't change row and column references - they are A,B,C or 1,2,3
you CAN however, use Tools>Options and turn off row and column headers - then you can use the 1st row and the 1st column to give whatever headers you desire (just format the background colour to grey or whatever)

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[Rome75]

Thank you guys,

I knew that...I wanted just to be sure...
..I'm going probably to hide the headers..
bye