if column equals text string clear cells

**wacky_diva** · 12-15-2013, 10:51 PM

Hello,
I would like to clear the value in every cell in the row, when column B = "R"

please help

**alansidman** · 12-15-2013, 10:56 PM

try this:

Please Login or Register  to view this content.

If you meant to clear the row of data and not delete the row, then change delete to clear in the code and the row will remain, however empty of data.

**berlan** · 12-15-2013, 10:57 PM

One way:

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 12-16-2013, 07:28 AM

Another:

Please Login or Register  to view this content.

**wacky_diva** · 12-18-2013, 06:40 PM

Hi guys thank for your great replies,
will this clear (not delete) the data in other columns or just B?

the data range I wish to clear is D:BC, based on the value in B

**alansidman** · 12-18-2013, 06:43 PM

If you look at the code I provided, it deletes the entire row. Replace the word delete with clear and it will clear the entire row. The other codes provided clear the contents of the cells. Have you tested any of the solutions?

**wacky_diva** · 12-18-2013, 06:49 PM

Wow! that was quick, thanks Alansidman, I don't want to delete the data in rows A:C or (BD onwards)

**wacky_diva** · 12-18-2013, 06:52 PM

Or shoud I say clear? No deleting please

**Debraj Roy** · 12-18-2013, 06:52 PM

If you want to Clear only D:BC.. try this one too..

Please backup a copy before try..

Please Login or Register  to view this content.

**alansidman** · 12-18-2013, 06:54 PM

This should do that for you

Please Login or Register  to view this content.

**wacky_diva** · 12-18-2013, 07:03 PM

I will do, made that mistake before

its falling over because I have merged cells, maybe a more specific range might help? the range is D7:BC300.

I am also using groups (Hidden) will this be able to clear them too?

**alansidman** · 12-18-2013, 07:07 PM

VBA does not play well with merged cells. If you want to use VBA, you will need to avoid the use of merged cells.

**wacky_diva** · 12-18-2013, 08:08 PM

Merged cells don't seem to play with any of the other kids.
I don't think I'll be able to avoid it though, but there are no merged cells in the D7:BC300 range.

**Debraj Roy** · 12-18-2013, 08:11 PM

Can we have a better view.. please upload sample file..

**wacky_diva** · 12-18-2013, 08:59 PM

Hi Debraj Roy,
Sorry I am unable to upload files from my workplace.

if column equals text string clear cells

LinkBack

Thread Tools

Rate This Thread

Display

if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Re: if column equals text string clear cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Apply formatting when column header equals string

[SOLVED] How to Extract A Number from String if Text within the String Equals XYZ

Delete rows in all worksheets where column A equals string

copying cells when column A equals certain text, loop function?

IF text string equals certain criteria then specified calculation

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions