Macro that clears cell contents on criteria

**traderdays123** · 06-23-2017, 08:23 AM

Hi everyone. I posted a question yesterday and got an answer that worked.I am not super knowledgable in VBA and would like to write a macro that clears cell contents of a range if they don't contain a specific string.
Excel example 2.PNG

So if you look at the image, you'll see that it's a bunch of gibberish. I want to be able to highlight from the second row all the way to the right and all the way down, then run a macro that clears all cells within my selected range which do not end in "US Equity."

Can this be done? Really appreciate the help.

**Aardigspook** · 06-23-2017, 08:42 AM

Try this code:

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 06-23-2017, 08:48 AM

This looks doable. However, can you please provide a worksheet with some dummy data too test on?

**sintek** · 06-23-2017, 08:55 AM

Something like this perhaps....

Please Login or Register  to view this content.

**PFDave** · 06-23-2017, 09:01 AM

I can't use selection to work backwards which is what I'd need for this to work, however this does the job for a sheet

Please Login or Register  to view this content.

**PFDave** · 06-23-2017, 09:03 AM

If you just want to clear the contents and not delete then

Please Login or Register  to view this content.

**sintek** · 06-23-2017, 09:04 AM

@ PFDave

OP requires cell to be cleared...

run a macro that clears all cells within my selected range

Edited:
To early, prior to other code posted

**PFDave** · 06-23-2017, 09:05 AM

Originally Posted by sintek

@ PFDave

OP requires cell to be cleared...

Edited:
To early, prior to other code posted

Got a version for that too

I like to speculate as well

Macro that clears cell contents on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Re: Macro that clears cell contents on criteria

Thread Information

Users Browsing this Thread

Similar Threads

Need Macro that clears data from cell but does not delete the content

[SOLVED] VBA Code that Clears contents of specific column in row

Clear cell macro clears other cells not recorded

Navivgation bar that activates selected sheet, then clears contents of the bar

[SOLVED] Macro which clears contents below X text until it encounters Y text

Macro that clears contents of all cells of certain colour (colour 35) in all sheets

Macro clears contents and my formula references

Bookmarks

Bookmarks

Posting Permissions