VBA: Deleting selection on multiple sheets

Trowa - Sep 3, 2009 at 08:24 AM
 Trowa - Sep 4, 2009 at 08:22 AM

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?