I have 2 worksheets, one with 1,000,000+ rows and the other with over 400,000. When I run a simple macro its extremely slow and gets stuck.
It is not a bugging error as the macro works when its a smaller file.
The macro works like this:
1. Analyzes another column within the same worksheet to find specific keywords and then label the associated category for each. E.g "ExpertsExchange.com", reference keywords to pick up from column a, experts,expertz,exparts, and output "Technology".
How do I improve the speed?