current system date

[ratman]

I need to know how to compare ( &gt; ) an activecell date read on an Excel spreadsheet by my macro (cell is already formatted as &quot;m,d,yyyy&quot to the actual current system date.<br>Global declaration for this????<br><br>My variable for this is currentdate as in.....<br>Sub readcell()<br>ActiveCell.Select<br>If ActiveCell.Value = Date Then<br>If ActiveCell.Value &gt; currentdate<br>

 

[ratman]

I LOVE ANSWERING MY OWN QUESTIONS......HEHEHEHE<br>ActiveCell.Select<br>dateman = ActiveCell.Value<br>If isdate(dateman) = True Then<br>GoTo isdateman<br>Else<br>End If