sa7med wrote: ↑Mon Apr 23, 2018 3:48 pm
Thanks for your post Wolf. I meant that it takes about 3-5 secs to cycle through all the sheets (all the racing for the day), not just a single sheet (that would be a disaster.) It used to be better, around 2-3, but the sheets got a little bigger and more complex - mainly that i started recording more selections (15 instead of 10). Ive been looking for ways to optimize but im no excel guru and only recently learned how to code.
OK good luck with that then. I guess you have got a few ideas for potential optimisation now.