gene2 Posted March 21, 2007 Report Share Posted March 21, 2007 Gene here I do alot in excel VB and I would like to know if ME has anything like VB (goto lineXX:). Or something equivelent. I need to jump to the end of a macro if condition is right. Thank You ahead of time. Quote Link to comment Share on other sites More sharing options...
Cory Posted March 21, 2007 Report Share Posted March 21, 2007 There is no GOTO command. But in my experiance of using a lot of logic and programming in ME I have never found it a problem. THere is always a way to structure conditons and repeats to avoid this shortcoming. Quote Link to comment Share on other sites More sharing options...
kevin Posted March 21, 2007 Report Share Posted March 21, 2007 Use Break to get exit out of a loop, use Macro Return to exit out of a called macro or to stop the topmost macro, and use Macro Stop to exit a macro. You can also use Repeat Until to perform a loop until a specific condition exists. Quote Link to comment Share on other sites More sharing options...
wbeldman Posted March 22, 2007 Report Share Posted March 22, 2007 Neither did I miss GoTo and there might be a better way to code your problem. But answering your questing, try something like Repeat 1 times Action01 If Condition = Right Break End If Action02 If Condition = Right Break End If Action03 If Condition = Right Break End If End Repeat FinalAction Note that I coded this without ME so please pay no attention to the syntax Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.