Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On error
Is "On error exit sub" valid? I am trying to use that and VBA does not like
that... Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On error
Did you look at the Help, Todd?
You can use a label just before the end of the sub: On Error GoTo Exit_Sub 'do stuff Exit_Sub: End Sub In article , "Todd Huttenstine" wrote: Is "On error exit sub" valid? I am trying to use that and VBA does not like that... Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On error
oh ok thanks. Yeah I just used a label but for some reason I thought on
error exit sub was an actual command. "JE McGimpsey" wrote in message ... Did you look at the Help, Todd? You can use a label just before the end of the sub: On Error GoTo Exit_Sub 'do stuff Exit_Sub: End Sub In article , "Todd Huttenstine" wrote: Is "On error exit sub" valid? I am trying to use that and VBA does not like that... Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |