|re: I am very sorry, I don't know how to make it any simpler for you|
I never asked you to make it any simpler for me. In fact, I understood exactly what you were trying to do.
All I asked for - repeatedly - was that you read the How To that I supplied the link to.
The How To had nothing to do with what you were trying to accomplish, but had everything to do with the proper way to post code on this site.
I see that by your last response, you still haven't read the How to.
Had you read it - and followed the instructions - your lastest post would have looked something like this:
Dim sh As Worksheet, sh1 As Worksheet
Set sh = Worksheets(1)
For Each sh1 In Worksheets
If sh1.Name <> sh.Name Then
Which piece of code do you find easier to follow - the code in this post, or the code in your last response?
When writing code, indents are used to set different sections of instructions apart from each other so that the code is easier for the reader to follow. You can tell what is inside the If-Then section, which in turn is inside the For-Next loop, etc.
The only way for those indents to show up in a post is if you follow the instructions in the How To that you can get to by clicking the How To link in the next line.
Posting Tip: Before posting Data or VBA Code, read this How-To.