+ Reply to Thread
Results 1 to 3 of 3

Debug error out of scope range

  1. #1
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Debug error out of scope range

    The problem - when I click on 'ENTER STORE NAME' i get a RUN TIME ERROR
    I just want the code to work withing C2:J6 - and be able to update all other cells without the error.
    What works now is:
    Clicking on the PART highlights the part in the screen table.
    Clicking the PART in the table, highlights all same parts in the table.
    Attached Files Attached Files
    Last edited by x65140; 11-19-2014 at 08:28 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,291

    Re: Debug error out of scope range

    Try this:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Re: Debug error out of scope range

    Awesome! Thanks!

+ 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] Debug error when .Range().Clear if range is empty
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2014, 02:37 PM
  2. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  3. [SOLVED] Scope of On Error?
    By Oppressed1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2013, 07:18 PM
  4. [SOLVED] Can't debug this code. The Arrays are producing a Subscript out of Range error
    By seigna in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 05:14 PM
  5. Debug Error - Subscript Out of Range
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2007, 07:06 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