Reply to thread

Message: [QUOTE="joemeshuggah, post: 6439637"] is it possible to do a find and replace with one statement using a variable? for example instead of: Selection.Replace What:="$", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Selection.Replace What:="-", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False is it possible to use Selection.Replace What:=MyChar, Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False instead? or can you not assign more than one character to a variable? [/QUOTE]