If you use

cells(5,y).Address

it will return to you

$L$5 when y = 12

I know this isn't exactly what you are after but by using a mid comman
you can get just the letter out.

mid(cells(5,y),2,1).Address

will return

L when y = 12

this would have to be modified if you know that you will be dealin
with more than 26 columns.

Not the method you were looking for but a possible work around

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=53038