Thread: Column function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sajit Sajit is offline
external usenet poster
 
Posts: 30
Default Column function

Thanks Vergel, exactly what I was looking for.

"Vergel Adriano" wrote:

=COLUMN(INDIRECT(F5))

where cell F5 has the text CZ108.



"Sajit" wrote:

I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of
another reference CZ108. Can some one help me with an expression to determine
this.

Sajit