You have rethink your strategy because Excel cannot be in edit mode and have
a macro running; one or the other, not both.
Why do need a continuous macro ?

NickHK

"mcolson" wrote in message
oups.com...
I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.