AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
I'm still having trouble with this... found this code
I'm not sure how to apply that, or test if it works.
Wouldn't I need to pass something in?
Any help appreciated.
Code:
Sub AddCommaToESIID()
Dim rCell As Range
If TypeName(Selection) = "Range" Then
For Each rCell In Selection.Cells
If Not rCell.HasFormula Then
rCell.Value = "," & rCell.Value
End If
Next rCell
End If
End Sub
I'm not sure how to apply that, or test if it works.
Wouldn't I need to pass something in?
Any help appreciated.