Dependent Validation Generates an Error

My code:

Please Login or Register  to view this content.

All of the variables have been declared and the first validation for column D works as expected but when we get down to the .Add for the second validation (for column E) I get a 1004 runtime error.

Any ideas?

Yes it does. If I try to add the formula manually I get an error telling me that the source generated an error and do I want to continue but it accepts the formula after I say yes. If I allow the code to add the formula it just generates a 1004 runtime error.

I managed to get it working by defaulting the cells in column D to a particular value and then ensured that the value was also in the lookup list that the validation for column E was using:

Please Login or Register  to view this content.

The error was being caused by the fact that the cells in column D were defaulting to a blank cell. Thanks for your help though.