Results 1 to 3 of 3

out of range error message

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2005
    Posts
    19

    out of range error message

    Hi,
    When running the following function, there will be an error message 'subscript out of range'. I can't get to the point, why this happens.

    If anyone has a suggestion, I would appreciate that.

    VBA:

    Sub Test()
    Dim lStart As Long, lEnd As Long

    With Workbooks("OutOfRange.xls").Worksheets("Information").Columns(2)
    On Error Resume Next
    lStart = .Find("Database Searches").Row 'first header
    lEnd = .Find("Holdings").Row 'second section header
    On Error Goto 0
    End With
    End Sub

    I also enclosed the file where this happens.

    Cheers
    Juergen
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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