|
-
May 3rd, 2013, 01:11 PM
#1
Thread Starter
New Member
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|