I have several routines in my Sub that all use an "if not". In the case of "if not" being true each routine does the same (see example). This makes the program length very long. Therefore I thought it would be nice if I could jump instead to the last "do various things" before End Sub. That way I could remove the "do various things" from each routine which would significantly shorten the Sub. How do I do that?
Please Login or Register to view this content.
Hi,
Have you tried the GoTo instruction:
HTHGoTo Line1:
Like this? If like this how do I find out the Line number? I don't have any Line numbers in my VB editor.
Please Login or Register to view this content.
What I want to do is illustrated in the example below. How does the actual script look like?
Please Login or Register to view this content.
Last edited by dschmitt; 02-26-2010 at 04:25 AM.
Perhaps....
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
yes, this is working. Thank you.
Going forward - do not post duplicate threads.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks