Hi I'm using the following code that replaces within a formula any text following "cleaner*[...]" (i.e. cleaner*Sheet1!B2) so would like to consider the whole string as the string to be replaced. Normally the formalua also has other contents.
![]()
Cells.Replace What:="cleaner*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False
Is that possible?
Bookmarks