Results 1 to 4 of 4

Run-time error 9 subscript out of range

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2018
    Location
    Arba Minch
    MS-Off Ver
    2003-2010
    Posts
    8

    Run-time error 9 subscript out of range

    Dear Excel forum users,

    This is Alazar from Arba Minch university Ethiopia and in a team we are conducting a research study on surface water hydrology using wetspa hydrological model.

    In doing this the model has been developed using excel and macros and i tried to follow the installation manual prepared by the developers, however whenever i run the program and click a button to update some worksheets based on the instruction and it is showing me the "Run-time error 9 subscript out of range". I tried to solve the issue by searching online but it is not helping me so i came to your forum seeking for support in fixing the issue. So i attached the file for you to test it and tell me how this issue can be resolved. in order to see the excel file open Oslovak\WetSpa\Model\Output then you will find WETSPA_ANALYSIS_TOOL.xls file and open it, then you will see the main page and click on the update all sheet then the error will come which i can't solve it and needs support on it. So to make all this happen you need to open the macro file and replace the file location according to where you place your file in 14 different lines. If you need any info on how to set up the model you can find it on the official web site ( i can to provide any link because i am new to this forum so please help me to figure out the issue).

    Any help to solve this issue will be appreciated and welcomed.

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run time error '9': Subscript out of Range
    By mklindquist0815 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2016, 12:35 PM
  2. [SOLVED] Run-time error '9': subscript out of range - error occurs on multiple computers except one
    By BrettE in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2014, 11:19 PM
  3. [SOLVED] subscript out of Range (Run time error 9), need help
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2013, 02:31 PM
  4. [SOLVED] Run Time Error 9 - Subscript out of range
    By kushmakarsharma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 08:02 AM
  5. Run Time Error 9 Subscript out of Range
    By Petrolcb41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2010, 08:43 PM
  6. VB Run-time error '9'; Subscript out of range
    By lisabethvw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2009, 03:49 AM

Tags for this Thread

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