I dont think you got my question right.

I have a macro wriiten for dong a series of actions. But this macro
should run once there is any change in the data that is updated from
the web by the web query. or else it should do nothing. How do i write
the code for this.The function onchange() does not work for web update
from query .Hence this doubt.

S Baloo

Don Guillett wrote:
Suggest you have your update done by a macro that also does the rest of your
project. It sounds like you want someone to do a project which is what many
of us do for a living.

--
Don Guillett
SalesAid Software

"Baloo" wrote in message
oups.com...
I have a sheet that updates infromation from web as web query.

On change in data (on update from web ) I need VBA to do some update in
other sheets and then print.Can some body help?