Hello

You must select the range in the worksheet_change event because any change
active the event

--
J a c q u e s

"TUNGANA KURMA RAJU" a écrit
dans le message de
...
I am having a web query in sheet1 (A1:E30) and it is based on a macro which
runs worksheet_change event.I am trying to add another 2 web querys to my
sheet from f1:k25,these are not based on macros.Whenever I am trying to
refresh these querys all are vanishing from my sheet and the first query
results are coming twice or thice instead.Why ? how to resolve this
problem?