DELETION OF TRIANGLES FROM COMPLETE COLUMN
 

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?

DELETION OF TRIANGLES FROM COMPLETE COLUMN
 

Do you mean the comment indicators? If so, select all those cells and do
Edit - Clear - Comments. HTH Otto
"MEANLEANDEANE" wrote in message
...
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?

DELETION OF TRIANGLES FROM COMPLETE COLUMN
 

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...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494834

DELETION OF TRIANGLES FROM COMPLETE COLUMN
 

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:

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?

--

Dave Peterson