+ Reply to Thread
Results 1 to 3 of 3

Disable Error Proofing

  1. 01-24-2018, 02:38 PM #1
    TimlmiT
    TimlmiT is offline
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    186

    Question Disable Error Proofing

    Gurus,

    I have tried disabling the error proofing to eliminate an annoying error. (Formula Omits Adjacent Cells)

    Please Login or Register  to view this content.
    Please let me know what I am doing wrong.

    FIY, I did close the file and reopened it.

    TIA,
    Tim
    Reply With QuoteRegister To Reply
  2. 01-24-2018, 04:04 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Disable Error Proofing

    Hello Tim,

    I am surprised you did not receive an error when this code ran. Try thses updates...

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 01-24-2018 at 05:46 PM.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 01-24-2018, 05:09 PM #3
    TimlmiT
    TimlmiT is offline
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Disable Error Proofing

    Leith,

    That was the trick..

    Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. error on disable/insert row disable code
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2014, 05:15 AM
  2. [SOLVED] Need Help Proofing My Formula - Thanks in advance!
    By carrothe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2014, 11:45 AM
  3. [SOLVED] Dummy proofing Excel VBA - If error exit sub
    By Zealotwraith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2013, 12:41 PM
  4. VBA for proofing cell reference
    By monkeywrench55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2011, 05:12 AM
  5. Proofing in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-31-2007, 09:38 AM
  6. User proofing an entry
    By L.White in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2005, 10:05 AM
  7. Error Proofing
    By Jasper in forum Excel General
    Replies: 1
    Last Post: 05-12-2005, 08:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1