Hello,
I'm doing several sumifs in my macro and it's taking like 30 seconds to do the calculation. Would it be better to just use the sumifs in the spreadsheet itself, without using it in VBA? I can't have my spreadsheet be so slow and lock up for that long. I thought doing sumifs in VBA would be better than doing the sumifs in the worksheet itself.
Thanks!
Bookmarks