View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to display the column name?

I get a formula under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, the character does not
change as I copy this cells into another location. does anyone have any
suggestions on how to display the column within Indirect function?
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

"Argy - Arcasoft" wrote:

What is the purpose and how far do you want to go left and down on the sheet
with those names?

Argy

"Eric" wrote:

Does anyone have any suggestions on how to display the column name?
For example, under column AB, I would like to display "AB" in cell AB1
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric