Hi,

How do I copy "Sheet1" to a new worksheet and make that the currently dimmed worksheet to add to?
Say Sheet6 exists, how do I create Sheet7?

There are several posts on how to copy a sheet but I need copy a sheet to a new sheet number and make it the active sheet for input.