Once again:
Name of the worksheet is neutral in this case, its position number in the
series of tabs which is important.
if your series of tabs is, e.g.
Abrakadabra, Sheet1, Sheet2,
then worksheet(1) shall be Abrakadabra,
worksheet(2) shall be Sheet1,
worksheet(3) shall be Sheet2.
But if you change the order of tabs, e.g. like below
Sheet1, Sheet2, Abrakadabra
then worksheet(1) shall be Sheet1,
worksheet(2) shall be Sheet2,
worksheet(3) shall be Abrakadabra.
You need not to change any sheet name, you only have to group the 3 sheets
you dont't want to run the macro on in the first 3 position of your series of
tabs, e.g. if names of these 3 sheets are Merged1, Merged2, Merged3, then
your series of tabs must look like this:
Merged1, Merged2, Merged3, Unmerged1, Unmerged2, ... , Unmerged100
--
Regards!
Stefi
„terilad†ezt Ãrta: