Thanks to all the others who posted alternate solutions!


"debartsa" wrote in message
...
Hi Everybody,

I'm working with the Excel 97 Object Model. Does anyone know of a way to
find the "column" value of a current cell?

For example let's say I have a reference to the cell at Address "B5" (I
won't know the address in advance at runtime). Is there a call I can make
to return just the column ordinal i.e. "B"

The closest I get is:
cell.Columns.Address(RowAbsolute:=False, ColumnAbsolute:=False)

which returns "B5"


Thanks for any help
Sam