Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
Converting letters to numbers | Excel Worksheet Functions | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
converting letters to numbers | Excel Discussion (Misc queries) | |||
row numbers & column letters | Excel Discussion (Misc queries) |