Cells.Replace What:=UserForm1.TextBox1.Text, _
Replacement:=UserForm1.TextBox2.Text, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
If I am typing in the above line as part of a VBA Macro in the IDE, intellisense helps me a lot. As soon as I type in "Cells." it shows me all...