Easy one..?

[Gromit]

Hmmm, I need a formula because I'm building an Indirect function.

Unfortunately neither of these formulas work for columns>26...

The one I came up with is hardly very elegant:

=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",ADDRESS(ROW(),COLUMN()),2)-2)

Maybe there's no easy solution after all?

Cheers

Gromi

 

[Frank Kabel]

Hi
as a suggestion: Don't use the A1 reference style but the R1C1 style in
INDIRECT then. Set the second (optional) parameter of INDIRECT to
FALSE.

 

[Ron Rosenfeld]

Hmmm, I need a formula because I'm building an Indirect function.

Unfortunately neither of these formulas work for columns>26...

The one I came up with is hardly very elegant:

=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",ADDRESS(ROW(),COLUMN()),2)-2)

Maybe there's no easy solution after all?

Cheers

Gromit

Well, the ADDRESS function takes numbers as it's argument, so perhaps if you
post the formula you are trying to come up with, we can come up with a more
elegant solution.


--ron