"sbdproj" skrev i melding
...
When I'm in cell C5 I want to put C in a variable (and not the columnindex
3), and when I'm in cell HD3 then I want to get HD instead of 212.

Can anyone help me with this?
I know I can get the whole adress from the activecell and then trim it but
I
guess that there's an easier way.

I don't think so
=MID(ADDRESS(1,COLUMN()),2,1+(COLUMN()26))
but hopefully I'm wrong.
--
HTH. Best wishes Harald
Followup to newsgroup only please