Excel 4.0 Macro (hopefully) simple questioin

I am writing 4.0 Macro code and have written the Macro to Find and Replace feature using the  Formula.Replace function. It works fine and replaces exactly what I need. The Macro then stops and the di...