+ Reply to Thread
Results 1 to 3 of 3

Subscript out of Range - But Array is in different workbook

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Subscript out of Range - But Array is in different workbook

    I have a WorkBook that has:
    Please Login or Register  to view this content.
    on the Worksheet SO Addendum

    Everything works great
    But if I open a new workbook - and type in a cell I get Error 9 Subscript is out of range

    When I click DeBug, it highlights
    Please Login or Register  to view this content.
    I suppose there needs to be an Active Worksheet phrase or something.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Subscript out of Range - But Array is in different workbook

    Try :

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Subscript out of Range - But Array is in different workbook

    Yes! That was exactly it

+ 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 - Array empty
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2014, 02:19 PM
  2. [SOLVED] Sheets Array - Subscript Out Of Range
    By goss in forum Excel General
    Replies: 2
    Last Post: 11-29-2012, 12:00 PM
  3. [SOLVED] Subscript out of range on Array
    By ZiadzExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 11:35 AM
  4. Subscript out of range error while populating array from range.
    By Aussiexile in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2010, 02:22 AM
  5. 1D Array Problem (Subscript Out Of Range)
    By John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2006, 02:10 PM
  6. [SOLVED] 1D Array Problem (Subscript Out Of Range)
    By John in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2006, 11:37 AM
  7. Subscript out of range - multi array
    By Buffyslay in forum Excel General
    Replies: 6
    Last Post: 02-15-2006, 10:15 AM

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