E
Ed
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
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