No cells were found error message

[daniels012]

Can I add something to my code??

With .Range("TimeArea").SpecialCells(xlCellTypeConstants)

Could I change this to an "if" question? Something like if any cells with constants exsist, then go on to clear contents, if not go on with the code.


Michael

 

[Andrew Poulsom]

You could use:

On Error Resume Next

 

[daniels012]

Andrew,
That works beautifully!!
Thank You,
Michael