On Fri, 31 Oct 2003 14:51:18 -0500, "Tom Ogilvy"
wrote:


Then have this macro write the data.

In xl2000 and later, I believe you can use the change event for this.

http://www.cpearson.com/excel/event.htm for a description of events.

If it isn't very difficult, can you give me an exemple of vba code?
I'm a novice

Thanks