VBA: Deleting selection on multiple sheets

Closed
Report
-
 Trowa -
Hello,

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,
Trowa

1 reply

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

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

CCM 2821 users have said thank you to us this month