Hi
just a question: For what do you need this?

--
Regards
Frank Kabel
Frankfurt, Germany

"LindaMac" schrieb im Newsbeitrag
...
When I use the Activecell.column statement it returns a numeric value
for the
column(ex: 27), I want the character value (ex: AA).

Here is a sample of my code, I always want to access row #1, but the
column
will vary based on the activecell location:

Dim sColumn as string
Dim sRangeName as string
Dim sValue as string

sColumn = activecell.column
sRangeName = sColumn + "1"
sValue = worksheets("sheet1").range(sRangeName).value