View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Diamond, Mark Diamond, Mark is offline
external usenet poster
 
Posts: 4
Default Name ranges and columns

I'm using MS Office Excel 2003. I'd like to be able to refer to a column by
a name so that I could use 'Price'23 instead of C23 and so forth. I thought
that I'd be able to do that by highlighting the column and then using
Insert-Name-Define or similar (I can't figure out the difference between
the Name-Create, Name-Define and Name-Label variations.

In any case, none of them seem to allow the kind of construction I'd like.
Do I have the syntax wrong in Price23 (for example ... how to separate
column and row parts) or is the whole thing impossible?

Cheers,

Mark