How do i get the column identifier in a variable

Posted by raj on September 26, 2001 6:01 AM

hi -

i am trying to dynamically build a formula row for columns
if c1 > 0 then c35 = c15/c1
for columns c through z
how do i do that.

i was wondering if any variable returns the current column, i.e, "c" or "d" ?

any comments appreciated.
thanks, raj

for

Posted by Aladin Akyurek on September 26, 2001 7:57 AM

The following returns the column number of the current column:

=COLUMN()

And

=ADDRESS(ROW(),COLUMN())

returns the address of the cell of this formula.

Aladin

=============