Copy and Rename a Sheet

**sreeks** · 08-28-2010, 12:41 PM

Hi All,

I found a macro in this forum which copies and renames the sheet to a specific name entered by the user in the dialogue box.

But the code copies entire sheet as it is.

I would like to know if we have to copy only the Format and Values and not formulas to the new sheet, is it possible to achieve this.

It would be really great if anyone can help me on this.

Regards,
Sri

Please Login or Register  to view this content.

**Marcol** · 08-28-2010, 12:48 PM

Hi sreeks

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

**sreeks** · 08-28-2010, 01:01 PM

Thank you Marco..

I will make sure this wont happen again..

**Marcol** · 08-28-2010, 01:07 PM

Try this

Please Login or Register  to view this content.

Hope this helps

**sreeks** · 08-28-2010, 01:14 PM

Hi Marco,

This is working perfectly. Thanks a bunch.. This will save a lot of time for me.

Added to this, is there a possibility to mention the sheet to be copied in a dialogue box rather than explicitly mentioning in the code.

The objective is to run the macro and mention the sheet to be copied, if sheet does not exist, it will throw a message. Once Input Sheet name is entered, we then enter the Output Sheet name as mentioned in the code..

Best Regards,
Sri

**Marcol** · 08-28-2010, 01:18 PM

Have a look again, you may have missed my edited Post.

I'll try to get back to you soon, got to sign off for a while.

Maybe someone else will help sooner.

**sreeks** · 08-28-2010, 01:46 PM

Hi Marco,

Thank you for the above code.
It perfectly does what I wanted to do.

True apologies for the redundant post. My only intention was to close the thread since you have already provided a solution for the question which I initially asked.

Best Regards,
Sri

**protonLeah** · 08-28-2010, 03:44 PM

Sorry wrong thread????

**sreeks** · 08-28-2010, 04:06 PM

Hi Photon,

I have opened a new thread since this is closed.

Kindly request you to refer the link below:
http://www.excelforum.com/excel-prog...t-to-copy.html

Best Regards,
Srikanth