Hi
in C9 user enters a customer number e.g. 124578

then in C10 user enters a date 16/3/2010

and from H20:H200 the user fails to enter required qty e.g. 2,5 or 100.

and runs a macro

when this happens the macro fails.

I want to stop the macro from being executed if all above 3 criterias are not fulfilled.

Can you please advise asap ... if possible.
Many thanks