Macro to delete contents of cells if user delete contents of other cells

**Stuartzz** · 05-22-2018, 08:08 PM

Hi there
The following event procedure macro copies formulas from d5 and i5:n5 to a particular row below if text is entered into any of the columns e:g in that row. I want to adjust it (see comments I have added to it) so that it deletes the formulas in columns d and i:n in a particular row that is below row 5, if cells in columns e:g in that particular row are cleared. So it’s kind of the reverse. i put some comments in to try to demonstrate what I am trying to do.

Please Login or Register  to view this content.

**teylyn** · 05-22-2018, 09:12 PM

Please edit your question and wrap your code in code tags.

**bakerman2** · 05-22-2018, 10:47 PM

Works fine for me.

Please Login or Register  to view this content.

**Stuartzz** · 05-24-2018, 02:24 AM

Thanks bakerman for doing that. I combined the 2 parts so that if you:
- add text to 1 of the cells in question then formulas are copied into the row, and
- if you delete text from one of the cells in question then formulas are deleted from the row.

But I would like it so that formulas from the row are only deleted if there is no text in all of the cells in question. Currently if there is text in 2 of the cells in question and you delete text from one of them, the formulas are automatically deleted. I would like it so that if you delete text from 1 of the cells in question, formulas are not deleted unless all of the cells in question are blank.

To illustrate I attached a sample file. If you delete the contents of cell g13, I don't want formulas to be deleted because there is still text in f13. So I suppose I was hoping that if text is deleted from g13, that the macro then makes sure that the range e13:g13 is completely clear before deleting the formulas.

Apologies for not being clear with my requirements and thanks for your assistance.

Please Login or Register  to view this content.

**bakerman2** · 05-24-2018, 03:25 AM

Try this way then.

Please Login or Register  to view this content.

**Stuartzz** · 05-24-2018, 08:22 AM

Fantastic! Thank you very much.

**bakerman2** · 05-24-2018, 08:28 AM

Glad to help and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Macro to delete contents of cells if user delete contents of other cells

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Re: Macro to delete contents of cells if user delete contents of other cells

Thread Information

Users Browsing this Thread

Similar Threads

Delete only some of a cells contents

[SOLVED] Delete contents of blank cells

Delete Contents of Cells with 0

Delete contents of cells

delete contents of visible cells only

[SOLVED] Delete Contents of Cells

[SOLVED] Delete specific cells contents in a row with some locked cells in the same row

Bookmarks

Bookmarks

Posting Permissions