Based off of text change, text will import into cells, breaks if text is cleared/deleted

**Butcher1** · 12-17-2015, 02:48 AM

I have the below macro code which based off of the N173:N184 drop down menu selection will copy the corresponding block of text into the designated range. The problem is if I clear or delete N173 (or any cell in the N173:N184 range) it throws an error. What I would like to happen is that by clearing N173, it clears out the range of cells that are linked to it. How do I modify the code to do that?

Please Login or Register  to view this content.

**protonLeah** · 12-17-2015, 03:35 AM

If the Target is empty, the Match function errors out. Maybe mod:

Please Login or Register  to view this content.

Based off of text change, text will import into cells, breaks if text is cleared/deleted

LinkBack

Thread Tools

Rate This Thread

Display

Based off of text change, text will import into cells, breaks if text is cleared/deleted

Re: Based off of text change, text will import into cells, breaks if text is cleared/delet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If chosen text from validation list is deleted display a text

[SOLVED] Change text color of selected cells based on a text value of another cell

Default text in 1 cell when blank - to remain once subsequent text deleted

Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

[SOLVED] Change text on one cell based on text in another

[SOLVED] Conditionally Change Text based on Previous Record's Text

[SOLVED] How can I change text to proper text in multiple cells.

Bookmarks

Bookmarks

Posting Permissions