Converting numbers to column letters
In a VBA procedure, I have two integers representing
columns. For example, integers are 1 and 5 are referring
to columns A and E respectively. From the two integers, I
would like to create a string representing the column
letters.
Basically,
1 and 5 should result in "A:E"
2 and 6 should result in "B:F"
3 and 27 should result in "C:AA"
I will be using the string to reference a range of
columns...Range("A:E"). Any ideas would be greatly
appreciated. TIA...
|