Results 1 to 3 of 3

Error msg. Subscript out of range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Error msg. Subscript out of range

    I am trying to get my head around some VBA and ran across a video series on you tube that seems to be easy enough for an old novice to grasp, however in a very early lesson I am trying to complete this example but I am running into a wall.

    When I try to run the following code I get an Error message "Subscript out of range" and I have been unable to get any further. I have tried renaming the target sheet but to no avail. I am at an impass. Any ideas?

    The series is done by Excel VBA is Fun. This is the link to the lesson.

    HTML Code: 
    Sub StartTimer1()
        nr = ThisWorkbook.Sheets("Timer").Cells(Rows.Count, 1).End(x1up).Row + 1
        Cells(nr, 1) = Time
    End Sub
    Thanks
    Jim O
    Last edited by JO505; 04-22-2014 at 12:35 PM.

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. Runtime Error - Subscript out of Range / Object Error
    By JHRice in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2012, 05:14 PM
  3. Defining Array - Runtime error 9, Subscript out of range error
    By MaartenW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-03-2012, 07:32 AM
  4. Subscript out of range error - save copy error
    By bg18461 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2006, 11:53 AM
  5. [SOLVED] Type Mismatch error & subscript out of range error
    By Jeff Wright in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2005, 03: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