ShowAllData
 

When a macro runs and it performs a filter/showall request the code stops on
the line:

ActiveSheet.ShowAllData

What needs to be changed so that this request is always performed regardless
if the sheet is not currently filtered.

Thanks if you can help.
Pat

If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If

Pat wrote:

When a macro runs and it performs a filter/showall request the code stops on
the line:

ActiveSheet.ShowAllData

What needs to be changed so that this request is always performed regardless
if the sheet is not currently filtered.

Thanks if you can help.
Pat

--

Dave Peterson

Pat

maybe just use:

Selection.AutoFilter

as a toggle

Regards

Trevor


"Pat" wrote in message
...
When a macro runs and it performs a filter/showall request the code stops
on the line:

ActiveSheet.ShowAllData

What needs to be changed so that this request is always performed
regardless if the sheet is not currently filtered.

Thanks if you can help.
Pat

Thank you gentlemen for your help. I found Dave's solution best suited for
this task.

Cheers
Pat
"Trevor Shuttleworth" wrote in message
...
Pat

maybe just use:

Selection.AutoFilter

as a toggle

Regards

Trevor


"Pat" wrote in message
...
When a macro runs and it performs a filter/showall request the code stops
on the line:

ActiveSheet.ShowAllData

What needs to be changed so that this request is always performed
regardless if the sheet is not currently filtered.

Thanks if you can help.
Pat