Using Advance Filter and referencing a Table name for the "List Range"

[SJ-NY]

Hi<o></o>
It has been awhile since my last post. I may be late to the party, but I have juststarted using Tables. Wish I got to theparty sooner.<o></o>
I use the Advancefilter in many of my projects. I usea range name to reference the “List Range” for the advance filter. I wasunsuccessful in referencing a Table name in the “List Range” in the AdvancedFilter List dialog box. I notice when Iselect the Table by using the Name box, the header row is excluded. So my question is simple, if it is possible,how to I reference a “Table” name as the List Range?<o></o>
Thanks<o></o>

 

[Momentman]

For a table named "Table1", you can use it in the List Range as "Table1[#All]" without the quotes

 

[SJ-NY]

Perfect - thank you