If you use worksheet code, it will be automatic, no button pushing.

I understand that H2 is where the comparison value is, but which cells are
the active cells when you click the button. This is where the worksheet
event code would apply.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"sidex " wrote in message
...
oke i think


the input range is in H2 450


if that's true ,tobad i need to use marco do this..(btw the macro in
the attached does work)


---
Message posted from http://www.ExcelForum.com/