Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row in an array
Hello
I have a program that is sensitive to speed. What is the most efficient way to identify and delete select "records" from an array (rows)? Is it computationally faster to paste the array to a worksheet or is there a macro or procedure where I can accomplish the objective with speed? Thank you W |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a row in an array
I will answer my question.
It is fastest to loop through the "dirty" array and port "good records" to a new array repository. No deletion necessary. W "cogent" wrote in message ... Hello I have a program that is sensitive to speed. What is the most efficient way to identify and delete select "records" from an array (rows)? Is it computationally faster to paste the array to a worksheet or is there a macro or procedure where I can accomplish the objective with speed? Thank you W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete a lookup table array name? | Excel Worksheet Functions | |||
delete an array | Excel Discussion (Misc queries) | |||
Clear/Delete an Array | Excel Programming | |||
How do I Delete Lines from VBA Array? | Excel Programming | |||
How do I Delete Lines from VBA Array? | Excel Programming |