Copy Worksheet To End & Rename

carlton123 · Feb 14th 2008

i want to copy a sheet and rename it and move to the end i have done this before but now ive redone code it asks the user for permission is it possible not too do this?

Will Riley · Feb 14th 2008

Re: Creating Copy Of Worksheet

I guess it is...but then i've no idea what's in your code that is stopping it from working as you'd like it to...

Try posting a question that is not so vague and you'll probably get a less vague answer

carlton123 · Feb 14th 2008

Re: Creating Copy Of Worksheet

ok i have a sheet called master and i need to copy it then rename it called sh(x) x being the next number. so ever time i need to create a new sheet it adds it at the end with the next number. getting the number is the easy bit for me. so what code do i need to copy and rename sheet but without it asking user for permission

thankyou!

turtle44 · Feb 14th 2008

Re: Creating Copy Of Worksheet

As Will pointed out, it would be extremely difficult for anyone to tell you what's wrong with your code since you haven't posted your code.

Dave Hawley · Feb 15th 2008

Re: Creating Copy Of Worksheet

Hover over Worksheet and read the numerous links.

[fa]*[/fa]

Copy Worksheet To End & Rename

Participate now!

Share