Hi there

On sheet1, I have a web query which refreshes every 5 mins.
On sheet2, I want to copy the data (in rows) of the sheet1 before the
web query refreshes.....
I am dividing this question in two parts :
1. how to catch the beforeRefresh Event?
2. Copy the data

Out of these two parts I need guidance, help on the first part only

Please......
Thanks in advance

Have a nice day
JohnBest