I have the following loop:
The loop is supposed to run 4 times to pull data off of a large monte carlo output worksheet and populate the actual report page that will eventually be handed to clients. For some reason it runs fine 3 of the 4 times and then gets hung up with the following error.
Run time error '1004': Unable to get the Percentile property of the WorksheetFunction class
I don't get how it can run through the procedure 3 times without any issues and then suddenly have an issue with the 4th time???
Any help would be greatly appreciated!
Bookmarks