Hi Mudraker,

This is certainly going to be a popular/much sought-after code. Good job! I think it would be better if the invalid postal code is cleared when the message is shown. Do you mind adding this last bit?

Gajendra, thanks also for your great input.

Regards,
Gos-C

__________________
Using Excel 2007/Windows XP

"It is better to be prepared for an opportunity and not have one, than to have an opportunity and not be prepared."