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


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=504406