Use other workbook to act as a 'stop-list'

Hi all,

Sorry - not a very good title.

I have a macro where I have hardcoded which rows are deleted based on the below code. However this list may need to be updated quite frequently. Is there anyway - so that I can have others update it themselves – I can have a link to an external worksheet, where say, whatever is in column A of that worksheet would act as a stoplist.

So for example if on this 'stop-list' I have the words 'please', 'delete' and 'me' in cells A1, A2 and A3 then these rows would be deleted. I think I would need up to about 50 words (i.e. A1:A50).

Is this workable?

Please Login or Register  to view this content.

Would this external workbook be already open?

Hi natefarm,

Sorry for the late reply. No the workbook would not be open but I guess I could use a Workbook Open event to open it and then hide it? I shall have a play with your code. Many thanks.

Hi nate,

Hmm I couldn't get it to work. I did as you said - named the range in other workbook 'DelList' and saved the workbook. I then reopened it and ran my code from another file (which contained some criteria for deletion) but upon running the code a dialog box opened up asking me to select a file to 'update values'.

But I already had Other Workbook.xlsx open?

After I cancelled it the code then deleted everything in Col A?

Hi nate,

Got it working. I just needed to change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Very good! If you need some ideas on how to optionally open the other workbook, this is one way:

Please Login or Register  to view this content.