"Tom Ogilvy" wrote in message
Why introduce application in the middle of a With statement. While it
may
work, it doesn't make sense to me when the simple inclusion of the period
would suffice.

It was highly contrived but based on the previous example to further
re-enforce what you and Dave had noted, particularly with regards to what
Range defaults to can be changed. Whilst very familiar to you perhaps not
to everyone. I wouldn't use that particular scenario.

Obviously, if Daves contribution were visible, I wouldn't have bothered.

I always appreciate anyone having taken the trouble to respond to any
question I have raised.

Regards,
Peter T