| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return column letter, rather than number?
Dim rng As Range
Dim cll As Range Set rng = Selection For Each cll In rng.Cells MsgBox "Cell " & cll.Column & cll.Row & "has a value of " & cll.Value Next cll Is there a way to format the .Column property to show the column letter designation instead of returning the column number? Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function that will look at letter in a column and return a number | Excel Worksheet Functions | |||
| Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
| Return Current Column Letter and Row Number | Excel Programming | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| How to return the row number or column letter as a variable? | Excel Programming | |||
Threaded Mode
