I want to be able to run a certain chunk of code in the macro if a certain condition is true, or if that condition is not true then I want to bypass that chunk of code. It doesn't matter if this is accomplished with an if... then... else statement, or some other way. I'm just looking for a general method for accomplishing this. Thank you!
Last edited by kenab1; 02-17-2010 at 03:55 PM.
Your question is too vague to be able to provide a specific answer. But If/Then/Else sounds very sensible. If you want more tailored advice, post specific details and a workbook.
Ok here's the code:
The first and second parts will always be run no matter what. I only want the third part to run if myNum is 3 or greater, otherwise I want the macro to skip it entirely. Thanks!
Please Login or Register to view this content.
Actually I figured it out. Thanks though!
I don't know but instructions are at the top of the page. Perhaps you could post your solution for the benefit of others.
I just added two If statements within the third section of the code, did the job nicely. Completely negates that section from running at all.
Please Login or Register to view this content.
Good work. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks