Clear contents in specific cell and the cells in the next 2 columns to the right

[JRidge]

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.

Please Login or Register  to view this content.

What i would really like to be Abel to do is :

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

[Vikas_Gautam]

Try this code..
I am sure ... I will work.. I may require some adjustments..

Please Login or Register  to view this content.

Waiting for *

[stnkynts]

This will work for 1 positive match of Kunde.Value. If you want multiple matches let me know.

Please Login or Register  to view this content.

[JRidge]

Thank you they both work.

Regards

jeremy