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

Activesheet.autofilter.mode = false
will remove the dropdown arrows (and show all the data)

With Activesheet
If .FilterMode Then
.ShowAllData
End If
End With

Will show the data, but keep the arrows.

Stan wrote:

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

--

Dave Peterson

Thanks Dave
That works like a charm... I used the second option ...

May you live to be 120 !! Have a good day