Exit Function inside With-End With block

[AlexanderBB]

Is this acceptable practice ?

 

[Michael M]

Can't see why not.....but you didn't ell us much either !

 

[AlexanderBB]

With Something
Do stuff
If some condition then exit Function
End With

If this Exits you're never hitting the End With.
It works, but may not be a 'good' thing to do. But as you're leaving the Function, it may not matter.
Just wanted to be sure.

 

[Michael M]

Maybe make sure before you exit, you re-enabled anything that may have been turned off, like
Screenupdating
displayalerts
enableevents
calculation......etc
that would normally be re-enabled at the end of the sub if it ran to completion

 

[Norie]

A With...End With isn't a control structure so I don't see if you 'exit' the function within one you aren't really going to be affecting anything.

Mind you, Michael has a good point regarding ScreenUpdating etc. but that would apply any time you were exiting something 'prematurely'.

 

[AlexanderBB]

Thank you, will carry on then. There's no screen updating or other hazards at the time.