Run macro after refreshing query

[smeyer56]

I am using Excel 2000 and have a sheet that is populated by a query. I have another sheet that is updated from the query's data using a macro. The query is set to refresh on open and every minute. What I need to do is automatically refresh the query(already working now) and then run the macro upon refresh comletion. Any ideas how I can do this?

 

[SkipVought]

Hi,

Check in microsoft.com for the afterrefresh event.

Carefully read and create your class module et all.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}