Macro help please

Giganews Newsgroups
Subject: Macro help please
Posted by:  TimmerSuds (TimmerSuds.29q7s3_1150849806.2026@excelforum-nospam.com)
Date: Tue, 20 Jun 2006

I have two columns:

D
06/15/06
07/01/06
05/10/06
08/10/06
04/10/06

F
3
3
1
2
3

I need to be able to incorporate the following into an existing
macro...

For any cell in column F that is not equal to 3 then blank out the
corresponding cell in Column D.

For example:
If F2=3 then do nothing..
If F4=1 then blank out D4

Can this be done from within a macro?

Thanks!

--
TimmerSuds
------------------------------------------------------------------------
TimmerSuds's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=35596
View this thread:http://www.excelforum.com/showthread.php?threadid=553873

Replies