Macro that copies sheet and places after the copied sheet every time

[goatie43]

Hi, I am pulling my hair out again trying to build a macro that copies a sheet and places it AFTER the copied sheet every time. Any help would be appreciated

Edit: I forgot to mention the sheet does not need to be renamed after its copied.

[NewGuy OnBlock]

Let's see the code

[goatie43]

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

[goatie43]

The sheet I'm trying to copy is in the middle of my 40 tab workbook, and the sheet that i copy is in the middle so if i can get it to place exactly after the copied sheet that would be great. But i suck at this....

[goatie43]

Hi Dave, this is what i had originally but not what i was looking for. Tanks for the input.

[davesexcel]

Hmmm... what indicates the sheet, or do you know exactly how many sheets from the last sheet?

Are you copying a sheet , and want it next to the sheet your copying?

[davesexcel]

Please Login or Register  to view this content.

[goatie43]

Please Login or Register  to view this content.

Sorry for the late reply just got back from work, This is what i ended up using thanks Dave!