Thread: If not then
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helmut Helmut is offline
external usenet poster
 
Posts: 111
Default If not then

I have the following statement:

With...
....
....

If Not IsError(.Cells(lr, "r")) Then Application.Run "Office_Payroll_2"

....
....
End with

After it Runs the Macro "Office_Payroll_2" it continues in the current Macro.
But I want it to "Exit the Current Macro after running "Office_Payroll_2"
and close all open workbooks without saving.
what do I need to add?