View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default ascii to character

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" wrote in message
ups.com...
can any one help me with a function which transforms ascii values to
character, tobe used in Macro for column referance