Advanced Filter Error

[csh8428]

For some reason I am receiving the following error when trying to write an advanced filter "Method 'Range' of object '_Global' Failed"
Weird thing is I have virtually the same code(the dynamic range and advanced filter part) in a another macro with just different names and it works fine there. The purpose of the filter is to display on the FICA OOBs sheet only items in the WT column of /403, /404, /405, /406 and the FICA OOBs column with a value < 0 using the criteria on the Filter_Criteria sheet. The range of the filter is a named Range I created based on the FICA OOBs sheet.

Please Login or Register  to view this content.

Thanks for nay help,

Craig

[jaslake]

Hi csh8428
Can't test your code...no workbook attached. This line of code will raise a #REF error in the Named Range

Please Login or Register  to view this content.

If you have spaces in the Worksheet Name when naming ranges you need to wrap the Sheet Name in single quotes

Please Login or Register  to view this content.