+ Reply to Thread
Results 1 to 3 of 3

Subscript out of range on other computers

Hybrid View

  1. #1
    Registered User
    Join Date
    06-03-2014
    Posts
    9

    Subscript out of range on other computers

    Hey all,
    I have a VB macro that works on my computer and have the error when running on other computers. I know the line of code that throws an error but don't know how to rephrase it to work on other computers in the network. The red shows what the debugger caught. THere are obviously several lines similar to this one, but what should I call the sheet then? Thanks!

    If UserForm1.MultiPage1.Pages("page2").Frame2.CheckBox1.Value = True Then
            mwb.Sheets("51.5").Copy wb.Worksheets(1)
        End If

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    Are the other computers using the same workbook(s)?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-03-2014
    Posts
    9

    Re: Subscript out of range on other computers

    yes, they just run the same workbook that i copy to the network drive...maybe that isn't what you're asking.

+ 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] 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
  2. [SOLVED] Subscript out of range
    By kgakhar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2013, 04:51 AM
  3. [SOLVED] Subscript Out of Range
    By vtxvtx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2012, 07:06 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. Subscript out of range error when trying to select a range
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2010, 07:57 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1