The function "Selection.Autofilter" can be used to add/remove an auto filter to a selected row. If a row has auto filters all ready on it, then using "Selection.Autofilter" removes these auto - filters. If a row does not have auto - filters then using "Selection.Autofilter" adds auto - filters to that row. Is then any way that I can run a "check" that will tell me if that row has auto-filters all ready set on it..?

Thanks a lot for the help.

asingh