Can we nest With / End With blocks of code safely? 1

[steve728]

While going through someone elses code I found nested With / End Withs. Is this asking for trouble?

Steve

 

[Trevil]

I have not had any problems with that. You could change it, but "if it ain't broke, don't fix it" may apply!

Learn from the mistakes of others. You won't live long enough to make all of them yourself.

 

[JoeAtWork]

From the MSDN Library:

You can nest With statements by placing one With block within another. However, because members of outer With blocks are masked within the inner With blocks, you must provide a fully qualified object reference in an inner With block to any member of an object in an outer With block.

Note In general, it's recommended that you don't jump into or out of With blocks. If statements in a With block are executed, but either the With or End With statement is not executed, a temporary variable containing a reference to the object remains in memory until you exit the procedure.