Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Exit function exit from the current function.
If you run the code using F8 (not F5) you will be able to understand it better If this post helps click Yes --------------- Jacob Skaria "Inkel" wrote: Wow, thanks. It's working. What's the logic behind "If billet = True Then Exit Function" ? All i understand when i read that is to end the function "autobus". Or does it mean to end the other function "vehicule" ? Thank you very much for your help. Inkel "Jacob Skaria" a écrit dans le message de news: ... Dear Inkel Functino modified. If billet = True then the function exists or else it will pick up the right one..... Try and feedback.. Function autobus(billet, region) region = Sheets("Frais dépl").Range("k8") If billet = True Then Exit Function For intTemp = 21 To 29 If region = Sheets("Frais").Range("B" & intTemp) Then autobus = Sheets("Frais").Range("E" & intTemp) Exit For End If Next End Function If this post helps click Yes --------------- Jacob Skaria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel and optimisation software.. | Excel Discussion (Misc queries) | |||
Calculation speed optimisation - Links and Dependency Tree | Links and Linking in Excel | |||
best approach for overcoming Input box errors & code optimisation? | Excel Programming | |||
optimisation tool for objective function macro | Excel Programming | |||
Financial workshops on Optimisation | Excel Programming |