Delete button to remove data from multiple sheets at the same time - Any Thoughts???

I'm super new to VBA, so this probably won't work. What if you replaced the "Set ws" command to = Sheets(Array("AnnualReview_Data", "EmployeeData"))

Hi Snick -

When adding that to the code I get an error: "Type Mismatch"

Best Regards,

John

I thought that would be too easy. I just recorded the action of grouping two sheets together and look at what the VBA came out as. Hopefully someone has a solution.

Try change to

Please Login or Register  to view this content.

Hi JIndon,

when trying to apply that suggestion I get the following error:

Compile Error: For without Next

John

Strange.
Just tested and it compiles here.

By the way, is "lstMyData" a global variable?

Hi Jindon,

It works - I must have missed something in the translation - Thanks so much !

"lstMyData" a global variable? is a global

John