ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Nested with structure (https://www.excelbanter.com/excel-programming/280240-nested-structure.html)

David

Nested with structure
 
Greetings,
Could one of you excellent people please help me out and
send an example of a nested With Structure (for my
education)
TIA
David

Tom Ogilvy

Nested with structure
 
With Worsheets("Sheet1")
With .Range("A1")
.value = 6
End With
With .Range("B9")
With .Font
.Interior.ColorIndex = 3
.Name ="Time New Roman"
.Size = 12
End With
End With
End With

--
Regards,
Tom Ogilvy

"David" wrote in message
...
Greetings,
Could one of you excellent people please help me out and
send an example of a nested With Structure (for my
education)
TIA
David




David

Nested with structure
 
Tom,
Thanks for taking the time to help me out, much appreciated
David


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com