ascii to character

G

Gautam

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

NickHK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASCII CODE of a character... 3
Illegal Character Imported 7
Map characters to their relative positions in a cell 3
line break character 5
Import File Line by Line 1
Delete ascii character 127 2
A Macro that gets data from an ASCII file 2
Incorporating feature of second macro into first? 5

Top