You can use Events to do this Reab

http://www.cpearson.com/excel/events.htm

If you need more help post back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Reab" wrote in message ...
I have a macro that will sort my data.
Is it possible to have the macro autorun whenever the
data is updated/changed?
If yes, how?

Thank-you for any suggestions offered.