I have the following loop in a Macro. I need to have the ON Error GoTo Label to Increase the ws by 1 and resume.
Please Login or Register to view this content.
I have the following loop in a Macro. I need to have the ON Error GoTo Label to Increase the ws by 1 and resume.
Please Login or Register to view this content.
Hi there. You could achieve this by having errorone just before the end of the for loop like this:
Please Login or Register to view this content.
Last edited by maclearyj; 04-06-2020 at 03:49 AM.
This would test if the sheet name exists...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
AlphaFrog, You nailed it! Ran some test and looks good. I struggled with his one for quite a while. Much better options than with On Error GoTo.
The attached code allows me to List the Tabs that are Missing. Staying at home, no golf, so posting scores to a new project.
Thanks again and stay safe and well.
Remember it is all Purple Smoke & MirrorsPlease Login or Register to view this content.
Last edited by wyowhite; 04-08-2020 at 11:59 AM.
You're welcome.
Alternatively (for posterity), you could create a custom IsSheet function...
...and call it with something like this.Please Login or Register to view this content.
Neither IsSheet or Evaluate("ISREF are ideas original to me.Please Login or Register to view this content.
Please add CODE tags around your post #4 code.
Last edited by AlphaFrog; 04-07-2020 at 06:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks