Query in Excel
 

Hi,

I have a webquery that returns information into sheet1...

Now I want to get the rows that have "ABC" in field no4
into sheet2.

I was trying to create a function in vba with the
following parameters:
results_from_webquery as array,
criteria_field as integer,
criteria as variant

Then I wanted the function to create an array that
contained only the rows that met the criteria and return
them to the cells next to the formula (on another
sheet)... this is not working out for me...

What is the best way to do this?

regards, Tomas

Query in Excel
 

See your LATER post

--
Don Guillett
SalesAid Software

"Tomas" wrote in message
...
Hi,

I have a webquery that returns information into sheet1...

Now I want to get the rows that have "ABC" in field no4
into sheet2.

I was trying to create a function in vba with the
following parameters:
results_from_webquery as array,
criteria_field as integer,
criteria as variant

Then I wanted the function to create an array that
contained only the rows that met the criteria and return
them to the cells next to the formula (on another
sheet)... this is not working out for me...

What is the best way to do this?

regards, Tomas