Unable to convert array to range while performing Autofilter

[sreeks]

Hi There,

I am trying to select a range and pass the range for Auto-filtering, for some reason, it is not happening.
I read in one of the articles that specifying a range will pick the first row in the range. Solution is to convert the range to array and pick each value in the column and then pass it on to AutoFilter.

But, Advance-filter does not take Criteria, it only takes Criteria Range.
I managed with lot of struggling to reach to the below state, however it is not working.

Request the forum members to help.

Regards,
Sri

Please Login or Register  to view this content.

[Norie]

What array/range are you referring to?

The CriteriaRange argument of AdvancedFilter has to refer to an actual range on a worksheet, you can't use an array held in memory.

If you did have an array in memory that holds the criteria then you would need to write its contents to a range and then use a reference to that range for the CriteriaRange argument.

[sreeks]

Hi Norie,

Thank you for the response.
I was trying to write the array contents to a range, but couldnt succeed doing it.
What I have done now is explicitly mentioning the name of the sheets where the range is picked up and is working.

Thank again for the support.

Best Regards,
Sri