Krishna,

Why not use 'xlErrors' instead of the number 16 (its numeric equivalent) since the term is more discriptive?
[vba]On Error Resume Next
Range("c8:c27").SpecialCells(xlCellTypeFormulas, xlErrors).EntireRow.Hidden = True
Range("c8:c27").SpecialCells(xlCellTypeConstants, xlErrors).EntireRow.Hidden = True
On Error GoTo 0[/vba]
Thanks,