I use the following to search 5000 rows and delete those that contain "YES" in column N. It is VERY VERY VERY slow, looking for optimization suggestions.
Thanks
![]()
Please Login or Register to view this content.
I use the following to search 5000 rows and delete those that contain "YES" in column N. It is VERY VERY VERY slow, looking for optimization suggestions.
Thanks
![]()
Please Login or Register to view this content.
Assuming you have a header in row 1.
OR![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Last edited by AB33; 07-02-2015 at 04:09 PM.
Wow, Amazing. I tried the first one and it worked perfectly and so much quicker than going line by line. Thanks for the quick response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks