Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column adjustments
I am writing the VBA code that is telling me what column a certain piece of
data is in...but instead of giving me the number of the column...is there someway through VBA that it i can get the letter reference. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
column adjustments
The code you would use depends on what you are doing to locate the column.
For example, if you have the column number, you could do this... ColNum = 4 ColLetter = Split(Columns(ColNum).Address(0,0),":")(0) If you have a cell reference that is in that column, then you could do this... ColLetter = Split(CellReference.Address(1, 0), "$")(0) There are lots of possibilities depending on what you are doing... can you show us the code you have so we can give you a specific answer. -- Rick (MVP - Excel) "dstiefe" wrote in message ... I am writing the VBA code that is telling me what column a certain piece of data is in...but instead of giving me the number of the column...is there someway through VBA that it i can get the letter reference. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
column adjustments
Here is a Function, courtesy Chip Pearson.
Function ColumnLetter(ColNumber) As String ColumnLetter = Left(Cells(1, ColNumber).Address(True, False), _ 1 - (ColNumber 26)) End Function To use the function in code, assume you have set a column number to variable myCol then: myColLtr = ColumnLetter(myCol) myColLtr will now equal an alpha column designation. "dstiefe" wrote: I am writing the VBA code that is telling me what column a certain piece of data is in...but instead of giving me the number of the column...is there someway through VBA that it i can get the letter reference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot adjustments | Excel Discussion (Misc queries) | |||
Row Height Adjustments | Excel Discussion (Misc queries) | |||
Adjustments | New Users to Excel | |||
Prevent Column adjustments? | Excel Programming | |||
Help! need some adjustments! | Excel Programming |