can any one help me with a function which transforms ascii values to
character, tobe used in Macro for column referance

You mean the Chr function ?

However, you can reference columns/ranges by number.
?cells(1,3).address
$C$1
?columns(26).address
$Z:$Z

NickHK

"Gautam" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> can any one help me with a function which transforms ascii values to
> character, tobe used in Macro for column referance
>

Check out OLH for ASC and CHR functions


--
HTH
Roger
Shaftesbury (UK)


"Gautam" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> can any one help me with a function which transforms ascii values to
> character, tobe used in Macro for column referance
>