having asked this question on many occasions and tried members
suggestions it always seems to kick up problems

i need to validate postcodes, once a postcode is entered manually or
selected from a listbox i need to validate it from a refrence list on
the same worksheet and have it flag up true or false when a match is
found

if there is a better way to ask this question could someone please
advise

thanx


--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=519156