Hi I am trying to add a "replace" function to a macro so that a part of an
equation in a worksheet can be changed. The syntax being used is
Cells.Replace What:="200907", Replacement:="200906", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
but I want the user to be able to change the 'What' and 'Replacement' values
via a dialogue box. Can anyone help please?