[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Advanced Filter box in Excel keeps asking for List range

Posted on 2011-03-17
1
Medium Priority
?
184 Views
Last Modified: 2012-05-11
Hello,

When using Advanced Filtering in Excel (2007), what would cause the List range field in the Advanced Filter box to come up empty each time after a previous filter?  

I've noticed that sometimes when it comes up, it is populated with the same range I defined previously (which is what I want).  However, at other times, it is empty.  Thus, I am trying to understand what determines each result so as to eliminate the one I don't want.

BTW, the Criteria range field is always constant so the problems lies only with the List range.

Thanks
0
Comment
Question by:Steve_Brady
1 Comment
 
LVL 24

Accepted Solution

by:
StephenJR earned 2000 total points
ID: 35159707
I think it depends on whether the active cell at the time is in your dataset.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

611 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question