Never ending loop

[Theodjinn]

Hi, the followng code should execute once but it seems to just keep going round in a loop. I reckon it's probably a simple mistake that is staring me in the face, but I can't see the trees for the wood.

Help appreciated!

Please Login or Register  to view this content.

[Andy Pope]

As you are changing the worksheet you are causing the Change event to fire thus running though the code and the loop again.

You need to disable events whilst processing your loop

Please Login or Register  to view this content.

[Theodjinn]

Brilliant!
Thanks for the help :o)

[Theodjinn]

One other thing you may be able to help with...

In the line:

Please Login or Register  to view this content.

It only seems to be comparing the DAY of the date, instead of the full date. How would I go about comparing the entire date?

[Andy Pope]

I guess it would depend on the content of the cell.
Have are the values in row 4?

[Theodjinn]

They are in the format dd/mm/yyyy.

[Andy Pope]

Now includes a time in the date format.
perhaps you should use DATE instead of NOW

[Theodjinn]

Still appears to be comparing the day only.....?

[Andy Pope]

post an workbook with a couple of example cells.
with values less, equal and greater than test value

[Theodjinn]

Here's a scaled down version...

Thanks again by the way!

[Andy Pope]

It's the transposing of UK/US date formats.

try this revision to the top of your routine

Please Login or Register  to view this content.

[Theodjinn]

Thanks for that Andy, much appreciated.

[Theodjinn]

Can a Mod mark this as SOLVED please?