+ Reply to Thread
Results 1 to 6 of 6

Run-time error 13

  1. #1
    Registered User
    Join Date
    03-04-2010
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2003
    Posts
    87

    Run-time error 13

    Hi fellow guru's and masters!

    Been a while since I posted and have reached a point whee I need to call upon your widsom.

    I searched and the "answers" I found didn't really answer my problem. I am having an issue with a macro that, had no problem last month and now I am getting.

    I ran the debugger and it points to the following:

    Please Login or Register  to view this content.
    The Line in "If Cells(J, "E").Value <> Div Then" at the bottom section, is apparently the problem.(or the first of a few)

    What do I look for to resolve this issue? I need help ASAP as I am trying to generate a report to be delivered this afternoon.
    Dawn - Guru in Training

  2. #2
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Run-time error '13' how to fix

    Try replacing "E" with the number 5 (no quotes needed)
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  3. #3
    Registered User
    Join Date
    03-04-2010
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2003
    Posts
    87

    Re: Run-time error '13' how to fix

    I will try and let you know if that works. Thanks for the quick response

  4. #4
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Run-time error '13' how to fix

    Any luck mate?

  5. #5
    Registered User
    Join Date
    03-04-2010
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2003
    Posts
    87

    Re: Run-time error '13' how to fix

    Crap! I forgot to follow up! Yes, it worked and now I will be closing out. Thank you for your help, it is greatly appreciated!

  6. #6
    Registered User
    Join Date
    03-04-2010
    Location
    Wisconsin
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2003
    Posts
    87

    Re: Run-time error '13' how to fix

    Just great! Now I can't seem to figure how to edit and mark it Resolved. sigh.......

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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