You can, but the object within the secondary With must be part of the
primary with object, or totally independent. You cannot refer to both with
objects from within either structure using the dot notation, one would have
to be fully qualified.

So you cannot do what you are trying to do.
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ChadF" wrote in message
...
Is it possible to have nested With statements ??

Problem I have - VBA application that refers back and forth between
workbook / worksheets. I have an 'exterior' With statement like this...

With Workbooks(ThisworkBook).Sheets(MySheet.Name)
' (some code)

Workbooks(AnotherWorkbook).Sheets(3).Activate
With Workbooks(AnotherWorkbook).Sheets(3)

' interior code here will make references to inner With
.Range("someRange").Value = ...

End With
End With

I want to refer to a range defined in the outer With ...is that possible
(and how ?)

Appreciate any advice.

Thanks,
Chad