No. I manually filtered the data just for my testing. (I didn't have any idea
how/what you're filtering, so I just did it through the userinterface.)

You can filter the range in code. Just record a macro when you do it manually.

Then you can add it to the complete code.

Milind Keer wrote:

Hi

Just gone through your code, and quick question, do I need to put filter
manually??

I have got several conditions and for each there is a different filter
criteria? and dont want to do that manually...

can we write a code to put filter?? if yes can you please share how??

Cheers!!
Milind

--

Dave Peterson