On Thursday, October 18, 2012 12:16:03 PM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 18 Oct 2012 21:12:34 +0200 schrieb Claus Busch:



Select Case ActiveCell.Value



change to:

Select Case Target.Value



Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Will do and thanks a ton. I archived your example for future ref.

See MISC post titled "Question regarding an auto-search facility" by D4WNO posted today. I passed your code on to that post, and will follow up with the small change you suggested.

Regards,
Howard