Multiple sheet copy paste with sheet clear

Hi everyone,

I have three sheets in my workbook. I am trying to clear the first sheet then copy and paste everything from the 2nd and 3rd sheet into the first one.

Right now the code is clearing the first sheet and copy everything from the 3rd sheet over to the 1st one but not the 2nd sheet.

Any thoughts on how to fix this?

Thank you in advance.

Please Login or Register  to view this content.

It worked, Thank you so much!!!!!

Originally Posted by Rachel5694

Please Login or Register  to view this content.

Don't use "Clear" as the macro name (variable name, etc.), because this is the name of the method in vba.

ps.: You can shorten your macro, e.g. in this way:

Please Login or Register  to view this content.