Duplicate Worksheet, Specify name

I am trying to create a Macro that will allow me to copy a specific workbook, and rename it.

I have the following code:

Please Login or Register  to view this content.

So this copies Sheet3, but strips out all of the formulas and resizes all of the columns. Can anyone suggest why it does that, and what needs changing to stop this happening?



ALSO...... am I right in thinking that Sheet3 will always be Sheet3 so i don't need to worry about the code falling over in the future?

Well, that seemed ridiculously easy

Please Login or Register  to view this content.