![]() |
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 |
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 |
All times are GMT +1. The time now is 11:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com