Results 1 to 9 of 9

Error checking routine - check range values on various worksheets and report if error

Threaded View

  1. #6
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 365 v2402
    Posts
    263

    Re: Error checking routine - check range values on various worksheets and report if error

    I think it might have something to do with this line:

    If cell.Value <> 0 Or cell.Value <> 1 Then include_range_error_flag = 1  'wrong value in Include range so make error flag = 1
    I changed it to look for cells that equal zero

    If cell.Value = 0 Then include_range_error_flag = 1  'wrong value in Include range so make error flag = 1
    This seems to work, i.e. if I change some of the ranges E3:E33 to zeros it reports those worksheet names, as it should. But the original line doesn't seem to work (look for values that are not a 1 OR 0)
    Last edited by TheRobsterUK; 05-29-2014 at 06:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-18-2013, 10:17 AM
  2. Error checking: make sure that ID values increase by one digit at a time
    By vzc8 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2011, 11:01 AM
  3. Disable Error Checking for only a range
    By jomili in forum Excel General
    Replies: 2
    Last Post: 11-04-2010, 02:03 PM
  4. Error Handling: Can it report line # where error occurred?
    By PingPing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2010, 03:47 AM
  5. Way to Turn Off Error Checking on a Range?
    By James Cox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-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