Hi Everyone,

Currently using Office 2010, Windows 7

I'm looking for code that will clear only the cells in named range [TOT_TIME1] if the cells (same row) in named range [CAT1] are empty.

I've tried the code below, but keep getting a "Type Mismatch" error.
If [CAT1].Value = "" Then
[TOT_TIME1].ClearContents
End If