Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the following code the uCol value is a number, I need the actual column
letter. Is there an easy way to convert the # to the correct column letter. I could us an array or a function with a select case but I have at least 180 columns that have to be done. The code is used to determine the location of a particular Agent's sales data for poping up a chart using that data. uAdd = ActiveWindow.RangeSelection.Address uCol = Range(uAdd).Column Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
convert column number to letter | Excel Programming | |||
convert column number to letter | Excel Programming | |||
convert column number to letter | Excel Programming | |||
check for alphabet in datalabel and then superscript that letter | Excel Programming |