Hi,
Is there a more efficient way to optimize the code below to improve its performance because on a large data set with over 20,00o records it is very slow?
Thanks in advance for any assistance that you can provide.
i
Please Login or Register to view this content.
It would be helpful to see a sample workbook (see yellow banner at the top of the page) but I don't understand why you seem to be testing the same conditions repeatedly , namely:
Please Login or Register to view this content.
Rory
Untested, but this might do what you want:
Please Login or Register to view this content.
Thanks a million rorya for your expertise. This works quit well. It cuts my time down to a fraction of my previous time.
Glad we could help.
Hi,
Since you're essentially testing three conditions, columns 10 & 11, 11 & 12 and 12 & 13 , and writing N/A to either columns 11:12, 12:18 or just 13, another approach would be to use a helper column and use standard Excel IF...Functions to flag it and identify which of the three is relevant.
Then all you need do is use an Autofilter three times and use the .SpecialCells(xlCellTypeVisible) syntax to update the relevant columns with the N/A.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks