If sh.name=Ws.name issue

Originally Posted by davesexcel

The code would not ignore the w1,w2,w3 worksheets, I had to use if then for each worksheet.
[....]

Please Login or Register  to view this content.

Use And instead of Or, to wit:

Please Login or Register  to view this content.

But if the code is truly as it is written, not an simplified abstraction, you already know the worksheet names. Why not simply:

Please Login or Register  to view this content.

Or if you prefer more structure:

Please Login or Register  to view this content.

You need to use And, not Or.


Regards, TMS

And it is.

I made the worksheet variables, thinking I was going to need them when I was going to paste to the Group Worksheets, turns out I didn't need them.

Code would be as such.

Please Login or Register  to view this content.