Do until you no longer firnd "#"

[schroederd1]

How do I write a Do Until Loop that will find "#" and replace with "0" untill there are no more "#". maybe a Do Until is not the best way to go about this. I'm open to any options.

thanks,
Donna

[frank_m]

Sub Macro1()
Cells.Replace What:="#", Replacement:="0", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub

Compliments of the Macro Recorder :)