Hi,
How can I copy 2 sheets - named A and B - (in the same file) and rename them say AA and BB, but if sheets exist to show a message whether to overwrite or not. If answer is to overwrite then overwrite else exit sub.
Thank you.
Hi,
How can I copy 2 sheets - named A and B - (in the same file) and rename them say AA and BB, but if sheets exist to show a message whether to overwrite or not. If answer is to overwrite then overwrite else exit sub.
Thank you.
Re: Copy and rename sheets
Hi,
Thanks for the reply but if you want to overwrite the sheet how do? I wrote that I want to create 2 sheets (actually more, but I hope I can change the code :wink:).
Re: Copy and rename sheets
you can delete the existing sheet, then copy the new
Re: Copy and rename sheets
How easy would it have been to be found quickly and have them removed. But I have over 150 sheets in the file. I would not have asked for help in this forum but so ...
Re: Copy and rename sheets
you started with 2 sheets, now please, explain better your problem
Re: Copy and rename sheets
Quote from patel;685947you started with 2 sheets, now please, explain better your problem
The problem is the same, from first post, but do not expect answers like this: "You CAN delete the existing sheet, THEN copy the new". A code to do what I asked in the first post would be perfect.
Re: Copy and rename sheets
Bump
Don’t have an account yet? Register yourself now and be a part of our community!