View Single Post
 
Old 07-05-2018, 09:15 AM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Code:
Sub Test()
    Dim rng As Range
    Dim cel As Range
        
    Set rng = Range("A1:Z100")  '<-- change range as required.
    Application.ScreenUpdating = False
        For Each cel In rng
            If cel.Value = "$-" Then cel.ClearContents
        Next cel
    Application.ScreenUpdating = True
End Sub
Reply With Quote