Running or bypassing code in a macro based on a certain condition...

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:

    Cells(4, 3).Value = 1
    newNum = myNum
    For newNum = newNum To (o - 7)
        Cells(4, 3 + newNum).Value = 1
        newNum = newNum + myNum - 1
    Next newNum
    
    Cells(4, 4).Value = 2
    newNum = myNum
    For newNum = newNum To (o - 7)
        Cells(4, 4 + newNum).Value = 2
        newNum = newNum + myNum - 1
    Next newNum
    
    Cells(4, 5).Value = 3
    newNum = myNum
    For newNum = newNum To (o - 7)
        Cells(4, 5 + newNum).Value = 3
        newNum = newNum + myNum - 1
    Next newNum

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!

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.

 

    If myNum = 3 Then Cells(4, 5).Value = 3
    newNum = myNum
    For newNum = newNum To (o - 7)
        If myNum = 3 Then Cells(4, 5 + newNum).Value = 3
        newNum = newNum + myNum - 1
    Next newNum

Good work. Thanks.