Return column letter, rather than number?
No, however try this:
Msgbox cll.Address(False,False) & " Has a value of: " & cll
--
Charles Chickering
"A good example is twice the value of good advice."
"Ed" wrote:
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
|