Problem with macro inserting row into advanced filter

[vanb]

I am new to macros and VB, so I may be missing something basic. I am having this problem:

I have a workbook with many worksheets, all of which refer back to Sheet1 such that each row on each sheet should match up (represent the same item). I created a macro to insert a row in each sheet at the same row number. It works fine for most sheets. However, the sheets which have advanced filters applied to them do not insert the line. I do not receive any error messages. I am inserting rows by copying a row and inserting it over itself so that the adjacent formulas are copied.

One notable exception: If the row where the new row is being inserted is not hidden on a sheet, it does properly insert.

Is the best way to accomplish this to have the macro turn off the advanced filter on each sheet, insert the row, then reapply the advanced filter? Any suggestions for such code?

Thanks.

 

[GMorris]

If all else fails, that's what I would do, it shouldn't take much time unless you have thousands of worksheets to do this with!

 

[Legacy 68668]

If you have filtered few worksheets then just do this before your macro

Sub test()
Dim ws As Worksheet
On Error Resume Next
For Each ws In Sheets
    ws.AutoFilterMode = False
    ws.ShowAllData
Next
End Sub