Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: VBA - ignore error in cell

  1. #1
    New Member
    Join Date
    Feb 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA - ignore error in cell

    Hi,

    I have copied a formula across a range of cells in VBA and some of the cells in the range contain an error once the formula is pasted (which is fine) but i need to get rid of that green triangle in the corner of the cell using VBA as the front sheet is an automated dashboard and it looks bad. Can you help please?

    Thanks

  2. #2
    Board Regular
    Join Date
    Jan 2010
    Location
    UK
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA - ignore error in cell

    You can change the settings of the Error Checking options. I think this should come up if you click on the cell with the error.

  3. #3
    New Member
    Join Date
    Feb 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA - ignore error in cell

    thanks, i know how to do it in excel but its supposed to be an automated dashboard so i need to put some code in the macro so that the error doesn't show....

  4. #4
    New Member
    Join Date
    May 2009
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA - ignore error in cell

    I have the same question... The code for such change would affect all cells like following.

    Code:
    Application.ErrorCheckingOptions.UnlockedFormulaCells = False
    I am not sure, if there is a manual way to only affect only one cell, like clicking on the exclamation sign and chose one of the options...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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