Link to home
Start Free TrialLog in
Avatar of zoeg
zoeg

asked on

Looping

   Cells.Find(What:="#N/A", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
        .Activate
    Selection.ClearContents

How would I repeat this for an entire work sheet?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DocM
DocM


Cells.Replace What:="#n/a", Replacement:="", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False

Cells.Replace What:="#n/a", Replacement:="", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False