Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
so how do you stop?
I've been using END to end a program (sub, macro). Now I read that isn't
good vba programing. What is good? John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
so how do you stop?
End Sub is the proper way to end a macro procedure. End Function for
Functions. End If, End With are all normal statements for VBA code. Perhaps what you are referring to is stopping the macro in mid procedure with just the End statement. That can be problematic. It would be safer to Exit a Sub or Function or an operation because that does not destroy anything. "John" wrote in message ... I've been using END to end a program (sub, macro). Now I read that isn't good vba programing. What is good? John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
so how do you stop?
P.S. Look up "End Statement" in VBA help file. That will explain all the
uses of End except for the End property which is an entirely different animal. "John" wrote in message ... I've been using END to end a program (sub, macro). Now I read that isn't good vba programing. What is good? John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop the "started office live" pop-up to stop. it is checked | Excel Discussion (Misc queries) | |||
How To Stop #Div | Excel Worksheet Functions | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Macro: With Stop it works. Without Stop it doesn't. | Excel Programming |