Interrupt macro within if statement

[be965]

I've witten a macro which has an if statement within a loop. It loops thru a range of cells checking whether each cell is null. If the loop encounters a null cell, I want to exit the entire macro. I have the loop and the if coded correctly. I just need the command to end the macro. Thanks

[Shijesh Kumar]

Please Login or Register  to view this content.

[be965]

Thanks Shijesh for the reply. This is actually not working for me. Here is the code:

Sub afRunMacrosACaACbACADAE()

Sheets("CUSIPs").Select
Range("F2").Select
Do Until ActiveCell = ""
If ActiveCell = "" Then
MsgBox " You must enter Issue and Issuer Description on the CUSIPs tab before proceeding."
Exit Sub
Else
ActiveCell.Offset(0, 1).Range("A1").Select
End If
Loop
Application.Run _
"acbValidateSeriesManualInputValues"
Application.Run _
"acMoveSinkingFundsDataSetsToSinkingFundFinalWorksheet"
Application.Run _
"adPasteSpecSerialCUSIPsToFINAL"
Application.Run _
"aePasteSpecSinkFundDataToFINAL"
End Sub

If my validation fails and the loop finds an empty cell, it throws the message, but the macro keeps running and excutes the other macros that follow the loop. Any ideas?

[Shijesh Kumar]

Please wrap your code between [-code] [-/code]

[be965]

Like this? Sorry, new to using macros and posting on this forum about them.

Please Login or Register  to view this content.

[be965]

Actually, maybe this is right?

Please Login or Register  to view this content.

[shg]

It's hard to help without knowing what your code is supposed to do.

[Shijesh Kumar]

Hi,

Are you getting the Message Box.. when you run code...

Can you post your workbook with dummy data with the logic...

[be965]

Actually the issue is with the second macro which also needs an exit sub statement. After making the correction, it works. Thanks for your help.

[Shijesh Kumar]

Cheers !!!

Mark the thread as solved :-)