Hi all,
I am currently using this Code to search column1 for a Key Word that is entered into textbox "Künde" on my userform.
What i would really like to be Abel to do is :![]()
Columns(1) .Replace What:=Kunde.value, Replacement:="", LookAt:=x1Part, MatchCase:=True
Search for the cell in column1 with =Kunde.Value
Clearcontents of this cell and the 2 adjacent to the right.
i.e.
Word is found in A7
Cells A7:C7 contents are cleared and fill Color returned to default colorindex 0
Any help would be appreciated
Regards
JRidge
Bookmarks