Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested With
Hi,
Is it possible to nest With... End With statements? Here is an example: With ActiveWorkbook.Sheets("Param") ' ... Set rng1stCol = .Range(.Range(strRange).Offset(2, 0), _ .Range(strRange).Offset(2, 0).End(xlDown)) For Each rngCell In rng1stCol With Me.lstTest .AddItem rngCell.Value .List(.ListCount - 1, 1) = _ Format(rngCell.Offset(0, 1).Value, "yyyy-mm-dd") End With Next rngCell Set rng1stCol = Nothing End With I just need some confirmation. Thanks. -- Jac Tremblay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested if | Excel Discussion (Misc queries) | |||
Nested IF? | Excel Worksheet Functions | |||
nested ifs not enough | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
What is quicker? Nested or non nested ifs | Excel Programming |