+ Reply to Thread
Results 1 to 2 of 2

Run time error '1004': Unable to get the Percentile property of the Worksheet....

  1. #1
    Forum Contributor
    Join Date
    03-13-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    136

    Run time error '1004': Unable to get the Percentile property of the Worksheet....

    I have the following loop:

    Please Login or Register  to view this content.
    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!
    Last edited by jerseyguy1996; 11-13-2009 at 03:52 PM.

  2. #2
    Forum Contributor
    Join Date
    03-13-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    136

    Re: Run time error '1004': Unable to get the Percentile property of the Worksheet...

    Okay I am an idiot. I was asking it to look at column number 30 and there were only 29 columns. It's fixed now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1