Consulting

Results 1 to 3 of 3

Thread: Sleeper: Run Time Error

  1. #1
    VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Sleeper: Run Time Error

    I thought I had this working for all occurances but I suppose not. At times it works fine but at other times it does not with the same kind of data formatted the same way. Presently I am getting a Run Time error on this line:

    If Not varS1(1, i) =
       varS2(1, i) Then
    I thought I had duplicates but I do not. I have attached my zip file. Thanks to anyone who can help.

  2. #2
    VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    I had to strip out the data in Col A due to privacy concerns

  3. #3
    VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    I also get a "Subscript out of Range" error sometimes also.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •