Macro Advanced Filtering - Criteria List length not fixed

[SimonVOwen]

Hello All,

I need to advanced filter a table.
I have a list of criteria that varies in length depending on what date I am looking at.
This is being driven and calculated by an extended macro which I need to insert this code into.
I have struggling to code into a macro how to account for this changing criteria list length as if I include any empty cells the advanced filtering fails.
Is there an easy way to code this into a macro?
It is hard to provide additional information as the criteria list can value from 50-250 values.

List Range is A1:N10000

Criteria Range is R1;R -random number

Regards,
Simon Owen

 

[SimonVOwen]

I coded a go around so ignore this question.