The code Lars posted is sheet event code and must be placed in the worksheet.

Right-click on the sheet tab and "View Code".

Copy/paste the code into that module.

Alt + q to return to the Excel window.

Select B10 and see Y appear in M6

Select C10 and see N appear in M6


Gord Dibben MS Excel MVP


On Thu, 10 Jul 2008 11:16:08 -0700, Stephen
wrote:

I et an object required error when running this. I am sorry but I dont know
enough to debug this.

Thx,
Stephen