+ Reply to Thread
Results 1 to 2 of 2

On error does not trap the error?!

  1. #1
    Registered User
    Join Date
    03-21-2005
    Posts
    2

    On error does not trap the error?!

    i've got this strange thing going on...
    any help would be appreciated.

    i have this small code:
    Please Login or Register  to view this content.
    when running this code on Excel with Microsoft Visual Basic version 6.0, it works like a charm and catches the "type mismatch" error i get on
    this line
    "If IsNumeric(Range(n.Name).Value) And Range(n.Name).Value <> "" Then"

    but when running this code on Excell with MVB version 6.3, it does not catch the error at all but just gives me the "type mismatch" error again!

    the reason for the "type mismatch" is that it fails over Range(n.Name) where my n.Name refers to a "Print_area"

    someone please help me?

  2. #2
    Registered User
    Join Date
    03-21-2005
    Posts
    2
    If someone would be so kind to take a look at my code.

    I need to get this problem solved by tonight for a client of ours...
    and the help-file isn't helping me out a lot

+ Reply to Thread

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