Agree with Dave on this - reduce your ranges to just what you need...or, say, 2-3 times what you think you will need, you are including over 1 million cells on those ranges...and in the calcs
Also, using SUMPRODCT can slow things down - especially when using such large ranges. Consider switching to maybe a sumifS() or countifS() function?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford,
Good point on the SUMPRODUCT thing. I had forgotten about that.
Dave
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks