+ Reply to Thread
Results 1 to 2 of 2

run time error 9 subscript out of range

  1. #1
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    209

    run time error 9 subscript out of range

    I am running this code and get the runtime error 9 message

    Please Login or Register  to view this content.
    I have a sheet called Data and Sheet2 I am looking for a value in A3 to end of column A in sheet Data. The value i am lookign for is on Sheet2 E2. E2 is where the user would enter the search term and Sheet Data column A from A3 onwards is where the search for that value will take place

    I don't think i have called anything by the wrong name

    Thanks any help will be appreciated

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: run time error 9 subscript out of range

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Subscript Out of Range Run Time Error 9: Please Help
    By Pauly723 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-23-2014, 06:30 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] Run-time error '9': Subscript out of range
    By billj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2013, 11:30 PM
  4. Run Time Error 9: Subscript out of Range
    By DanManly in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 11-15-2012, 03:07 PM
  5. Run-time error '9' - Subscript out of range
    By mgphill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2012, 10:08 AM
  6. Run time error-subscript out of range
    By ldd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 01:37 PM
  7. [SOLVED] run-time error '9': Subscript out of range
    By AccessHelp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2005, 01:05 PM

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