+ Reply to Thread
Results 1 to 3 of 3

Macro To IGNORE ERROR - Cell With Formula / Green Arrow Error

Hybrid View

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,471

    Macro To IGNORE ERROR - Cell With Formula / Green Arrow Error

    .
    I have a macro that deletes ENTIREROW. Works great.

    There are several columns with formulas. Whenever a row is programmatically deleted ... the columns with formulas .. the next row below the deleted row
    is displayed #REF. I was able to correct that using this macro after the row deletion :

    With Sheets("Main Data").Range("K3:K250")
            .Cells.Formula = "=IF(G3="""","""",SUM(G3:J3))"
           .Cells.FillDown
    End With
    The macro programmatically refills the column with the appropriate formula for each cell.

    PROBLEM: Now when a row is deleted the next row cell has a small green arrow in the upper left corner, indicating an error. Of course, I can click the cell, then the green arrow and select
    IGNORE ERROR and the green arrow disappears.

    BUT -

    Is it possible to write a macro that will click the green arrow and select IGNORE ERROR ?
    The macro recorder doesn't work for this action and I am unable to find a solution on the .Net and Forum.

    Thanks for reading and assistance.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,471

    Re: Macro To IGNORE ERROR - Cell With Formula / Green Arrow Error

    .

    Do you see anything wrong with using this in the project ? If so, what and how to overcome the issue.


    Thank you.

     With Sheets("Main Data")
            With Application.ErrorCheckingOptions
                .BackgroundChecking = False
                .EvaluateToError = False
                .InconsistentFormula = False
            End With
     End With
    Last edited by Logit; 07-26-2018 at 05:40 PM.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,471

    Re: Macro To IGNORE ERROR - Cell With Formula / Green Arrow Error

    .
    I'm so sorry no one thought enough to comment on my question.

    Have a nice day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-30-2017, 09:19 AM
  2. Macro error, Formula cell showing a green triangle in top cell
    By sherry_1991 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 02:09 PM
  3. #Name Error in function, cannot run function with green arrow in editor.
    By staplegunz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-29-2011, 11:50 AM
  4. Macro to ignore #N/A error for charting
    By Philb1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-13-2011, 05:32 PM
  5. Excel Formula Error - Green Triangle in Cells
    By harrywaldron in forum Excel General
    Replies: 2
    Last Post: 06-25-2007, 01:06 PM
  6. [SOLVED] how can i ignore an error in a formula
    By hotelmasters in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2006, 08:20 PM
  7. Ignore Error in Formula?
    By theillknight in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2005, 11:03 AM

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