Clear content based on date?

Hello All, I'm looking for some help on a formula that would clear the content of a cell based on a date. In column B, I have some currency data, and other data. In column C, I have certain due dates. Once the due date has passed, I'd like to have the data in column B clear itself.

COL B	COL C
$100.00	04/07/2012	Clear $100.00 on 04/07 or later
$100.00	04/10/2012	No action until 04/10

Any ideas?

Thanx....LT

Hi
Try this:

Sub CLEARCONTENT()
Dim rcnt As Long

rcnt = Range("B" & Rows.Count).End(xlUp).Row

For i = 1 To rcnt
If Date >= Range("C" & i).Value Then
Range("B" & i).ClearContents
End If
Next
End Sub

Regards...

Thanx, I'll give this a try and reply back.

LT

Ya sure...
If it helps u then pls click the star below...

Regards..