plse correct the above vbaPlease Login or Register to view this content.
plse correct the above vbaPlease Login or Register to view this content.
THis is VBA, I will move it to thatr forum for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this:
Regards,Please Login or Register to view this content.
tt3
Hi, asdzxc,
3 ways fo doing so: error handler, loop through all sheets, use a function to determine whether a worksheet exists.
Please Login or Register to view this content.
Please Login or Register to view this content.
[ Edit ]Please Login or Register to view this content.
Forgot about Evaluate as most of the time:
[ /Edit ]Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 09-22-2013 at 02:57 AM. Reason: added one more way, corrected aerror in colde-line
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I like this: easy & short
Please Login or Register to view this content.
Hi, tuongtu3,
I donīt because I realized that there was one character missing in the sample. Code should look like
Code posted earlier would create new sheets but be unable to rename them accordingly.Please Login or Register to view this content.
Ciao,
Holger
sloved thank you
Hi, asdzxc,
could you please mark the Thread as Solved via Thread Tools over the first post?
Ciao,
Holger
Thanks Holger.
asdzxc,
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks