Read this webpage Stu about Events
I think this is what you need??
http://www.cpearson.com/excel/events.htm

Look for the Change Event


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



"Stu" wrote in message ...
Is it possible to have a macro that is constntly running, so when
something is changed in the spreadsheet the macro updates so the macro
doen't have to keep being ran?

Thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/