Solved: Trigger code from SQL Query refresh

[peacenik]

I have some code that I would like to run immediately after each time I refresh my ODBC query in a spreadsheet. Can someone please tell me what event I can use to trigger my code.

[lenze]

Untested, but I believe a query refresh will trigger a Worksheet_Change event, so you could us that to fire your query.

lenze

[peacenik]

Thanks. That did the trick perfectly.

[geekgirlau]

Peacenik, don't forget to mark this thread as "Solved" using the Thread Tools at the top of the screen.