VBA: Deleting selection on multiple sheets [Closed]

 Trowa -

I would like someone to write a VBA code for the following action:

On the sheet "Verlofoverzicht" I've got a list of names. Both front- and backnames in column A and B.
When I select one or more names I would like to find them on the following sheets: "Januari", "Februari", "Maart", "April", "Mei", "Juni", "Juli",
"Augustus", "September", "Oktober", "November", "December".
Then delete the selected names on all mentioned sheets.

So for example when I select the name John Doe on sheet "Verlofoverzicht" and run the VBA code, the name John Doe will be erased from sheets "Verlofoverzicht", "Januari", "Februari", "Maart", "April", "Mei", "Juni", "Juli",
"Augustus", "September", "Oktober", "November", "December".

Please let me know if more details are needed.

Best regards,

1 reply

How do I search for a selection spread over two cells?
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!