Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a collection of ranges
Hi Gary,
Try: Range("A1:D1,E40:R40,T120:AA120").Clear --- Regards, Norman "Gary''s Student" wrote in message ... What is the syntax to create a collection of ranges? Currently I use an array of strings: Sub dural() s = Array("A1:D1", "E40:R40", "T120:AA120") For i = LBound(s) To UBound(s) Range(s(i)).Clear Next End Sub What I would like to do is: rColl = whatever dim r as Range For Each r in rColl r.Clear Next -- Gary''s Student |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a collection of named ranges using wildcard characters? | Excel Programming | |||
Alternitive to Collection of Ranges | Excel Programming | |||
Retrieving the Collection of Ranges in a Workbook | Excel Programming | |||
Retrieving the Collection of Ranges in a Workbook | Excel Programming | |||
Deleting named ranges by looping through range collection | Excel Programming |