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

**JRidge** · 07-03-2014, 10:18 AM

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** · 07-03-2014, 10:43 AM

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** · 07-03-2014, 12:05 PM

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** · 07-04-2014, 01:25 AM

Thank you they both work.

Regards

jeremy

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Clear contents of specific cells on the same row if a specific cell on that row is empty

Macro to clear only the contents of the cells which have a specific font colour

Code to clear contents of specific cells based upon if key exists in other sheets

Clear contents of cells that do not contain specific text, sort cells that do

Hid and unhide and clear contents for specific columns at the same time

Bookmarks

Bookmarks

Posting Permissions