Stephen Bullen also has a UDF that'll display a filter's criteria. You can
find it on John Walkenbach's website:

http://j-walk.com/ss/excel/usertips/tip044.htm

HTH
Jason
Atlnata, GA

"Scott Fendrich" wrote:

I want to be able to display the criteria that a user has selected while
using filters in Excel. The only way I currently know how to check my
criteria is by looking for the blue arrows!