a oke. well i'm very noob in this . i'm sorry for that. but could yo
give a sample of a code..
yeah i didn't but a range a cell, becaurs every cell you can use this
you could say every cell is an active cell
Bob Phillips wrote:
*If you use worksheet code, it will be automatic, no button pushing.
I understand that H2 is where the comparison value is, but whic
cells are
the active cells when you click the button. This is where th
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 macr
in
the attached does work)
---
Message posted from http://www.ExcelForum.com/
--
Message posted from
http://www.ExcelForum.com