Macro help please

[TimmerSuds]

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!

[jindon]

deleted....

[jindon]

deleted...

[jindon]

try

Please Login or Register  to view this content.

[Gary''s Student]

Sub gsnu()
For i = 1 To 65536
If Cells(i, "F").Value = 3 Then
Else
Cells(i, "D").Clear
End If
Next
End Sub

--
Gary''s Student


"TimmerSuds" wrote:

>
> 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...o&userid=35596
> View this thread: http://www.excelforum.com/showthread...hreadid=553873
>
>