Hi.

I have recorded a macro to remove filters from data lasts in advance of
performing other actions.

However if the data is unfiltered the macro falls over with the message
Run time error '1004' ShowAllData method of Worksheet class failed.

I think I need some sort of if error continue code or something to check
filtering
first.

I would be grateful if someone could point me in the right direction please.

Hi Philip

Try

If Activesheet.Filtermode Then ActiveSheet.ShowAllData

--
Jacob


"Philip J Smith" wrote:

Hi.

I have recorded a macro to remove filters from data lasts in advance of
performing other actions.

However if the data is unfiltered the macro falls over with the message
Run time error '1004' ShowAllData method of Worksheet class failed.

I think I need some sort of if error continue code or something to check
filtering
first.

I would be grateful if someone could point me in the right direction please.