VBA Clear Cells for one range if cell in other range is blank
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
Re: VBA Clear Cells for one range if cell in other range is blank
if cat1 is multiple cells in multiple rows i would believe you would need to do something like
Code:
For Each c In Range("x").Rows(2)
for the specific row you are working with