Can We access same object in sing Loop more than 1 time with "With..End With" statement?

[Chirag R Raval]

Dear Sir,

just for clear of concept...of VBA ...
Object, Range or selection...
if we require various process on same Object, Range or selection...
Can We access same object in sing Loop more than 1 time with "With..End With" statement? or we must apply any other code for that?

where to catch(Hold) & where to Leave object for Each process in Single Loop?
may be this concept goes beyond outside of scope of loop...

I Don't Know but there are some point I guess.

Dear Administrator:- though this question about VBA (Macro) related,
please just move this question if you feel or wish on your .ORG's proper
VBA forum if I wrongly ask this question in this VBA forum..

Hope you focus on this point..

Regards,
Chirag

 

[Marc L]

Hi !

Use With statement to "lock" an object
and any loop within the With … End With block …
​

 

[Chirag R Raval]

Dear Sirs,

If you advance lock with referenced previous 2 or 3 parent of target Object, range, Selection, then you can process its various aspects in Single loop..

am I right?

regards,
Chirag Raval

 

[Marc L]

Difficult to exactly foresee what you mean but for sure
there is no issue when Logic & Excel object model are respected …​