Hi
I still cant get this to work (dont know what i am doing wrong)
if a copy a sheet after sheet one the copy button will work regardless of what the second sheet is named, but if i add another sheet when i press the button the pop up says all items coppied but nothing happens.
When i copy the sheet the call searchforstring is in the coding in each sheet? there are no errors ?? have you any ideas

Did you get it to work on my test file ???

Peter