Macro that skips to another macro if no numbers are found

[Andrewstupendo]

Hello All,
I need a macro that skips to certain macro (e.g. "Macro_X") if the macro cannot find any numbers separated by a blank space either before or after said numbers in a range (B4:B). If the macro does, in fact, find numbers separated by a blank space before or after them along with any text, then the macro simply ends.
I have attached an example with two worksheets showing the two different scenarios. In the first worksheet (without separated numbers), the macro would skip to "Macro_X" and in the second worksheet (with separated numbers), the macro would end.

Best,
Andrewstupendo

[LeoSkywalker]

This macro will do. Need to insert it in a module:

Please Login or Register  to view this content.

[Andrewstupendo]

Hello Leoskywalker,
The macro worked quite nicely if no separate numbers were found in the spreadsheet.
However, I received the attached error message if numbers were, in fact, present.

Also, I realized that the macro that needs to be "skipped to" is part of the larger chained-together macro.
Therefore, the "sub-macro" (i.e. Macro X) within the context of the larger macro needs to be referred to
in order to avoid shutting down the larger macro.
So in other words, code is needed so that if no numbers are found and one skips to "Macro_X",
the larger macro still needs to function. I apologize if I did not explain this earlier.
e.g.

Please Login or Register  to view this content.

Best,
Andrewstupendo

[LeoSkywalker]

You ghave inserted the code in a WORKSHEET, you need to insert the code in a MODULE, please see the file attached.

[Andrewstupendo]

Thanks for that.

[LeoSkywalker]

You're welcome, you can mark the post as solved.

[Andrewstupendo]

Hello LukeSkywalker,
There is another aspect to this problem that I want to address.
Namely, that the macro which you created is now part of a larger macro.
So, my question: if there are no numbers found using your macro, FindNumbers,
is it possible to end the larger macro that it is a part of and then call another macro like myDummyMacro which is NOT part of
Larger_Macro?
here is the code for the Larger macro.

Please Login or Register  to view this content.

Your code for FindNumbers would be designed so that the Larger_Macro would end in the
middle of its run if no numbers were found and then FindNumbers would call on myDummyMacro.
So your code would look something like this I suppose:

Please Login or Register  to view this content.

I apologize for this oversight and that I did not think of this before.
Best,
Andrewstupendo

[LeoSkywalker]

It's not possible to do it the way you want it, because when you call another sub, no matter where ig goes, or what it does; it will always return with the next line.
if you want to transfer the control to control to another sub, then it has to be the last line, see the example:

Please Login or Register  to view this content.

[Andrewstupendo]

Thank you once again LeoSkywalker, for the solution to my second problem. Great job! Andrewstupendo. P.S. I would add another star to your reputation, but the website does not allow.,