It's not a dynamic solution. You would need to hook it into a
Worksheet_Change event procedure to make it appear dynamic. Chip Pearson has
a page or two on Excel events:

http://cpearson.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"grandfilth" wrote
in message ...

can this be used dynamically? I've been trying it but cant work out how
to use it...
i would like it to work when u change the input data without having to
press anything else...


--
grandfilth