Microsoft Office Questions? Ask a IT Expert for Support ASAP
subscript range means the array is not being populated for whatever reason . you can try supressing all errors by adding
On Error Resume Next
at the begining of the script, this of course may cause the macro to not function all together , but it should not throw and error.
let me know what this does, it may cause it to not populate althogether or wierd vvalues to occur, let me know if this happens and I can try looking in the code deaper to see if i can cause the array to not populate
OK I placed your line of code at the start of each macro - turned off automatic calculation and it worked without error -
For each macro it said there should be 99 Top Scores which was obviously wrong but what it did show was the VERY FIRST RESULT ONLY. I checked and it did return the very best result but only one results where there should have been 11 for the mile etc.
So you are correct it is not populating the entire list of Top Ten results - it comes up with the first one and then it must crash.
Unfortunately I have to return the MAC book that I borrowed and will not be able to get another one for about a week - so if you can think of a work around for this problem - GREAT but I will not be able to test it for a while.
Thanks for your help so far I think you are getting close!!!!!!
i will look at it further , however as a time saver you might want to consider replacing the mac with a pc. or if you must use a mac, consider using paraleels to run the pc version of excel.