Thanks,

One more question.

The value in each cell in column F is stored in a variable called
cellDate i then us the DateAdd function to add 4 days to the cellDate
and store the new date in a variable called returnDate.
I then want to compare the returnDate variable with the systems date
using the Date function and if the returnDate is = to the systems
date, colour the row red, if not skip the row and check the next row.
The loop statment should check the cell in each row and compare it
against the system date.


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=546494