Clear Cell Containing Done And The Proceeding Cell

**ajocius** · 12-22-2017, 07:52 AM

I get spreadsheets with lots of data which is not relevant to me. The unwanted data typically has a text name in one cell for example in cell A1 and in B1 will have the word Done. This pair, random text and Done appears throughout my spreadsheet. In those cells which have the word Done, how can I clear the contents of both the preceeding cell and the cell with the word Done in it. A typical spreadsheet can have 1000's of instances of Done and a preceeding cell which have no use to me. I would like to do this in VBA 2016. Your assistance would greatly help a saturated engineer. Thanks.

**AlphaFrog** · 12-22-2017, 08:50 AM

So if B11 had Done in it, you want to clear A10, B10, A11, B11; is that correct? And do that for all cells in column B that have Done?

**ajocius** · 12-22-2017, 09:05 AM

Oops, I see the error in my request. Sorry. If B11 had Done, then clear contents of A11 and B11. Starting at row 11, there could be a dozen instances of Done in one cell and in each case the preceeding cell and the cell with Done need to be cleared. So for example if B11, E11, AB11, AF11 had Done then clear A11, B11 and D11, E11 and AA11, AB11 and AE11, AF11. There could be thousands of rows. Please excuse my gaffe.

**AlphaFrog** · 12-22-2017, 09:31 AM

Please Login or Register  to view this content.

**ajocius** · 12-22-2017, 09:44 AM

Would I substitute B:B for B:DDD to get a large swath of columns?

**AlphaFrog** · 12-22-2017, 09:57 AM

Please Login or Register  to view this content.

**ajocius** · 12-22-2017, 11:32 AM

It works great. Thank you and Merry Christmas.

**AlphaFrog** · 12-22-2017, 11:40 AM

You're welcome and thanks for the feedback. Happy holidays.

Clear Cell Containing Done And The Proceeding Cell

LinkBack

Thread Tools

Rate This Thread

Display

Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Re: Clear Cell Containing Done And The Proceeding Cell

Thread Information

Users Browsing this Thread

Similar Threads

VBA to Clear 1 Cell and Clear other cells Formula only

Clear merged cell contents in comand button(clear all)

VBA to clear contents of the cell in a column of data in a cell starts with specific word.

Macro to clear cell content if cell on the same row is modified based on a drop down list

[SOLVED] move down column and for every blank cell, clear contents of cell to the left

a macro to clear a range of data based on cell result - i.e. if A1 = A2, clear C1: C10

Macro that will clear contents of cell based on format of text in adjacent cell

Bookmarks

Bookmarks

Posting Permissions