Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop calling sub Intentionally without error.
Hi all,
I am trying to find a way to stop all sub's from running if certain conditions are encountered. sin the example below, if row count is less than 50 I would like to stop sub_1 from running. All of the posts i find on this subject are related to errors. this isn't really an error just a condition. Thanks for any advice. BRC sub _1() call sub_2 do some stuff end sub sub_2() if range ("somerange").rows.count <50 then msgbox("Less than 50 rows") exit sub else end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to intentionally set a variable to 'error' (iserror(x) = true) | Excel Programming | |||
Intentionally not validate Sub or Function | Excel Programming | |||
Intentionally truncating text characters | Excel Discussion (Misc queries) | |||
Error 49: Bad .dll Calling Convention | Excel Programming | |||
Bad DLL Calling Convention (Error 49) | Excel Programming |