Board index » Excel » DELETION OF TRIANGLES FROM COMPLETE COLUMN

Excel110
Is there a way of deleting the coloured triangles from all the cells in a

column at the same time,instead of having to delete each one individually?


-

Do you mean the comment indicators? If so, select all those cells and do

Edit - Clear - Comments. HTH Otto

"MEANLEANDEANE" <MEANLEANDEANE@discussions.microsoft.com>wrote in message



-

If it's green triangles, you could try unchecking "Formulas referring to

empty cells"



Tools/options/error checking



TGHC





--

tghcogo

------------------------------------------------------------------------

tghcogo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10494

View this thread: http://www.excelforum.com/showthread.php?threadid=494834



-

Could you mean the Error warnings (in the upper left)--little (usually) green

triangles.



If yes, you can use a macro:



Option Explicit

Sub testme01()

Dim myCell As Range

Dim myRng As Range

Dim wks As Worksheet

Dim iCtr As Long



Set wks = ActiveSheet

With wks

Set myRng = .Range("f1", .Cells(.Rows.Count, "F").End(xlUp))

For Each myCell In myRng.Cells

'1 xlEvaluateToError

'2 xlTextDate

'3 xlNumberAsText

'4 xlInconsistentFormula

'5 xlOmittedCells

'6 xlUnlockedFormulaCells

'7 xlEmptyCellReferences

'8 xlListDataValidation

For iCtr = 1 To 8

With myCell.Errors(iCtr)

If .Value = True Then

.Ignore = True

End If

End With

Next iCtr

Next myCell

End With



End Sub



If you're new to macros, you may want to read David McRitchie's intro at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm



MEANLEANDEANE wrote:

--



Dave Peterson

-