lior03
12-29-2005, 12:12 AM
hello
the following macro turn every cell in a selection that contain a formula
to a red font.
what about an error nessage?.suoopse there are no cells that have a formula
how do i get a msgbox say it?.
thanks
Application.ScreenUpdating = False
On Error Resume Next
selection.CurrentRegion.Select
selection.SpecialCells(xlCellTypeFormulas).Select
selection.Font.ColorIndex = 3
selection.Font.Bold = True
Application.ScreenUpdating = True
the following macro turn every cell in a selection that contain a formula
to a red font.
what about an error nessage?.suoopse there are no cells that have a formula
how do i get a msgbox say it?.
thanks
Application.ScreenUpdating = False
On Error Resume Next
selection.CurrentRegion.Select
selection.SpecialCells(xlCellTypeFormulas).Select
selection.Font.ColorIndex = 3
selection.Font.Bold = True
Application.ScreenUpdating = True