This should be easy but...I tried several times and it did not work.
I have a macro that downloads information from an accounting program.
While working on the data I use Auto filter to sort out the
information .. The program works great but while I have filtered data
and I try to get another account (with rows hidden) It stops the
macro. I need for Excel to recognize that there is filtered data and
if so to "show all the rows". Then continue to download the new
info. Any great ideas?

Thanks
Stan