LinkBack URL
About LinkBacks
Hello,
I have a Team Generator! sheet with a macro to randomly generate teams by clicking the green shape 'CREATE TEAMS'. It seems to work but is taking a long time.
Can someone please see why this is so slow?
Thank you very much for your help,
XJ
Hello,
I have a Team Generator! sheet with a macro to randomly generate teams by clicking the green shape 'CREATE TEAMS'. It seems to work but is taking a long time.
Can someone please see why this is so slow?
Thank you very much for your help,
XJ
.
How long does it take for your machine ?
Mine : 4 secs.
Win 10 / 64 bit / Excel 2007
It went from a few seconds to about 30 now. I thought maybe the code is not efficient.
Thank you Logit for replying.
Nice adaptation to the code - it takes between 11 and 12 seconds using:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you but I don't understand???
I am not trying to time the run of the code. I just noticed that it is running slower than before for some reason.
Do you think my 'CREATE TEAM' code can be improved to run faster?
Well - it's not skipping anything now. Unsure whether it can be sped up
Okay I appreciate you taking a look. I suppose I will leave this open for now.
You're welcome and thanks again for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks