That's just the strange little text editing package M/soft give us here - the
line's word wrapped when it shouldn't! I've tried to correct it below but no
doubt more hard returns will creep in. The "If" up to the "Then" after it
should all be on one row.

Having said that, Bob's solution is better because you don't see gaps in the
dropdown list unlike my rather unorthodox method!

"nick_thomson" wrote:


Thanks Bob and Martin for your replies.

Bob's solution may be too complicated as my workbook has many sheets,
so I tried Martin's macro solution first.

I followed your instructions Martin, but I get a compile syntax error
on the red 'if' below:

If Not IsEmpty(Target) Then
If
ActiveWorkbook.Names("inputrange").RefersToRange.F ind(Target.Value).NumberFormat = ";;;" Then
Target.Value = ""

I'm pretty hopeless with VB - any ideas?

Cheers

Nick


--
nick_thomson
------------------------------------------------------------------------
nick_thomson's Profile: http://www.excelforum.com/member.php...o&userid=32929
View this thread: http://www.excelforum.com/showthread...hreadid=527536