I know i have done this before, maybe i am just having a bad day. For some reason this is giving me an error. It will make a new sheet with the correct name, then a new sheet that is just "Sheet #" and then error out. what am i doing wrong?
Please Login or Register to view this content.
Last edited by GaidenFocus; 11-18-2011 at 05:14 PM.
GaidenFocus,
Give this a try:
Please Login or Register to view this content.
Last edited by tigeravatar; 11-18-2011 at 03:28 PM.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
When you create a new sheet, it becomes the activesheet. You need to keep a reference to the sheet you are on. A less confusing code may be:
Please note you will still get an error if you try to name a sheet the same name as an existing sheet, or if your cell has no value (because you can't name a sheet null).Please Login or Register to view this content.
A bit more advanced would be this, which will warn you if one of those two conditions exist:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
ah yes, simple. forgot that the sheet was losing focus. thanks dave! im going to stick with this though
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks