programming help

S

Stan

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
 
D

Dave Peterson

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.
 
S

Stan

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

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