How many nested With...End with can be process in VBA?

[Chirag R Raval]

Dear Sirs,

How many nested With End with actions possible through Excel VBA?

if possible, then how to track?, what should used put as remark on every nested With end with statement?

Hope there are found some fundamental & advance, pointed towards, need to deeply understand points about With End With statement.

Regards,

Chirag Raval

 

[Debaser]

There is, as far as I know, no limit. From the point of view of maintenance, anything more than about 3 levels is unpleasant.

Why do you ask?

 

[Chirag R Raval]

Dear Sir @Debaser,

Thanks for reply.
& yes , you are seems right, because more then 3 nesting , hard to maintain .

Because when open more then 3 workbooks , if we are on 1st , there are we usually say or use "With activeworkbook", but after jump to another , use also there another With..End with , & then jump to another ....so in point of first,
we must release it with "End With " somewhere in code, but on which point ? this confused the matter.

Regards,

Chirag Raval

 

[Debaser]

Why do they need to be nested at all? If they refer to separate workbooks, I see no reason to nest them inside each other. Nesting With blocks should only really be done when you want to use a With block referring to a property of the prior With block. For example if you have a Range object in a With block and then need to alter several font properties, like this:

With Range("A1")
    With .Font
        .Bold = True
        .Size = 12
    End With
    
    .Value = "Look at me, I'm bold!"
End With

 

[Chirag R Raval]

Dear Sir @Debaser ,

Thank you very much for focus on core concept of nesting "With... End With".
Hope there are further something important to know about With..End with may be found.

Regards,

Chirag Raval