i've done more testing, i did find that if i replaced the
worksheets('sheet1").showalldata with

selection.AutoFilter Field:=3
I no longer get an error if the filter is being used or not.

I do have another question though. the items that are being filtered
are being re-numbered all the time, so, i'm just wondering if there is
a way to set the filtering back for the user since i have undid the
filter to do the math calculations.?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements