Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
Hey guys
Below is an example of how I created my collection called "testCollection". Dim TestCollection As New Collection I have a code that loops through a range and adds items to this collection. How do I clear all items in the collection? Thanks Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
Hi Todd
you as a quite regular poster should know not to multipost :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag ... Hey guys Below is an example of how I created my collection called "testCollection". Dim TestCollection As New Collection I have a code that loops through a range and adds items to this collection. How do I clear all items in the collection? Thanks Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
I didnt multipost. Why do you say I multipost?
-----Original Message----- Hi Todd you as a quite regular poster should know not to multipost :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag ... Hey guys Below is an example of how I created my collection called "testCollection". Dim TestCollection As New Collection I have a code that loops through a range and adds items to this collection. How do I clear all items in the collection? Thanks Todd . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
Hi Todd
the same question from you appeared in public.excel.misc :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag ... I didnt multipost. Why do you say I multipost? -----Original Message----- Hi Todd you as a quite regular poster should know not to multipost :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag ... Hey guys Below is an example of how I created my collection called "testCollection". Dim TestCollection As New Collection I have a code that loops through a range and adds items to this collection. How do I clear all items in the collection? Thanks Todd . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
Oh I wondered why my messages were not showing up. I am
at work and when Im at work I have to access the newsgroup through Microsoft.com. THe default newsgroup it goes to first is General Questions which is apparently the misc group you are talking about. I see 2 of the same posts in there. Sorry I did not intend for them to go to the misc. I never use that group anyway. Thanks. I figured out what was going on with my code. I found out that in order to remove items from a collection, you must use the .remove method. I was saying .remove (variable) and it was not working. It kept leaving 1 item in there. When you remove an item in a collection, the index resets to 1. I did not know this, so instead I used .remove 1 and then it worked. Tod Huttenstine -----Original Message----- Hi Todd the same question from you appeared in public.excel.misc :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag ... I didnt multipost. Why do you say I multipost? -----Original Message----- Hi Todd you as a quite regular poster should know not to multipost :-) -- Regards Frank Kabel Frankfurt, Germany "Todd Huttenstine" schrieb im Newsbeitrag news:5bf901c48160$55af4590 ... Hey guys Below is an example of how I created my collection called "testCollection". Dim TestCollection As New Collection I have a code that loops through a range and adds items to this collection. How do I clear all items in the collection? Thanks Todd . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing all items in a collection
Hi Todd,
Todd Huttenstine wrote: Thanks. I figured out what was going on with my code. I found out that in order to remove items from a collection, you must use the .remove method. I was saying .remove (variable) and it was not working. It kept leaving 1 item in there. When you remove an item in a collection, the index resets to 1. I did not know this, so instead I used .remove 1 and then it worked. Another option is to destroy the collection (Set TestCollection=Nothing). I've found it to faster, not to mention less code. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
How do I find clearing items in a column in Excel? | Excel Discussion (Misc queries) | |||
Adding Unique Items to a Collection | Excel Discussion (Misc queries) | |||
How do I find clearing items in a column in Excel? | Excel Worksheet Functions | |||
Problem with assigning values to items in collection | Excel Programming |