I currently use a lot of loops in my macros. Someone recently introduced me to arrays and they seem to be much faster at running through the data. However, when an action needs to be taken, it has to access the sheet again and this seems to be just as slow. Is there a way to run through the array and save all the necessary changes? Then execute all the changes in one step at the end? Here is the code.
Please Login or Register to view this content.
Your array is correct, but you can not use or test properties in arrays, hence you used.
Arrays live in memory, but you are testing property of a range, not array, if you do, you will get an error.Please Login or Register to view this content.
Hi Jiptastic,
Although that's true, you probably only need to access the sheet a relatively few times - so by passing the array the processing will still be much quicker. You can disable the screen updating to save most of that access time:However, when an action needs to be taken, it has to access the sheet again and this seems to be just as slow.
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Perhaps next code
Please Login or Register to view this content.
Your code could be improved to mix array and range.
Please Login or Register to view this content.
PCI this seems to be my answer. Setting screenupdating is also a good suggestion. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks