+ Reply to Thread
Results 1 to 12 of 12

Run Time error 9 Subscript out of range

  1. 04-28-2016, 03:28 AM #1
    kaseyleigh
    kaseyleigh is offline
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Run Time error 9 Subscript out of range

    Hi

    I get Run Time error 9 Subscript out of range, I cannot see where the error is
    Please may I ask for some advice?

    Much appreciated!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-28-2016, 04:01 AM #2
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,109

    Re: Run Time error 9 Subscript out of range

    Hello KaseyLeigh,

    That particular error usually means that the code cannot find where it it supposed to copy or paste or transfer data to/from.

    I suspect that this line is your problem:-

    Please Login or Register  to view this content.
    You have not specified a range to paste the formula to,e.g. Range("A2:A20").

    You may have to post your whole code, just in case.

    Cheerio,
    vcoolio.
    Reply With QuoteRegister To Reply
  3. 04-28-2016, 04:21 AM #3
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,109

    Re: Run Time error 9 Subscript out of range

    ...............or you could try this:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.
    Reply With QuoteRegister To Reply
  4. 04-28-2016, 04:22 AM #4
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,109

    Re: Run Time error 9 Subscript out of range

    ...............or you could try this:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.
    Reply With QuoteRegister To Reply
  5. 04-28-2016, 04:57 AM #5
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,109

    Re: Run Time error 9 Subscript out of range

    ....and i have no idea why it posted twice!
    Reply With QuoteRegister To Reply
  6. 04-28-2016, 05:14 AM #6
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Run Time error 9 Subscript out of range

    Do you definitely have a sheet with the exact tab name 'Sheet1'?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  7. 04-28-2016, 06:31 AM #7
    kaseyleigh
    kaseyleigh is offline
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Re: Run Time error 9 Subscript out of range

    Hi lovely people

    Mmm ... changed my code to select the cell User picked then next line of code is ..

    Please Login or Register  to view this content.
    and I get Run time error 1004 Application-defined or object-defined error ..... eeeeeek!
    Reply With QuoteRegister To Reply
  8. 04-28-2016, 06:36 AM #8
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Run Time error 9 Subscript out of range

    Can you post the rest of the code as it is?

    Also, an explanation of what you are trying to do would help.

    PS If you just want to put =1+1 in the user selected cell you could use this.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 04-28-2016, 06:45 AM #9
    kaseyleigh
    kaseyleigh is offline
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Re: Run Time error 9 Subscript out of range

    Hi Norie (thanks for your time!)

    Here's my full code.
    I am copying a formula and want User to pick a cell to paste the formula into

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 04-28-2016, 06:59 AM #10
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: Run Time error 9 Subscript out of range

    Where do you get the error with that code?
    Reply With QuoteRegister To Reply
  11. 04-28-2016, 08:34 AM #11
    kaseyleigh
    kaseyleigh is offline
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Re: Run Time error 9 Subscript out of range

    at Line myCell.Formula = " .......


    basically I want formula =VLOOKUP([@[Fund Name]],PKRFactsheetSelection.asp!$A:$F,6,FALSE) inserted into cell user picks
    Last edited by kaseyleigh; 04-28-2016 at 08:42 AM.
    Reply With QuoteRegister To Reply
  12. 04-28-2016, 08:57 AM #12
    kaseyleigh
    kaseyleigh is offline
    Forum Contributor
    Join Date
    10-29-2009
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    125

    Re: Run Time error 9 Subscript out of range

    Norie

    it works I was being a div "DOH!"

    Thank you for your time and knowledge!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run Time Error 9: Subscript out of Range
    By xyza12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2015, 03:56 AM
  2. Run-time error 9 Subscript out of range
    By amber_skanpur in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-04-2014, 12:31 PM
  3. [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
  4. Run Time Error 9: Subscript Out of Range
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2011, 01:44 PM
  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. Run-time Error '9': Subscript out of range
    By tryaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2009, 02:13 PM
  7. run-time error '9': Subscript out of range
    By jerredjohnson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2006, 03:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1