Copy and Insert Row problem when AutoFilter is ON
 

Hi,
I help my co-worker to build a excel tool. the basic idea is, since the
whole worksheet is protected, and only certail range was allowed to
insert/delete row. I decide to add 2 small +/- image and put code after them:
for insert row, it will copy current row and insert right after it. This
works just fine in most case.
now I have a problem, when AutoFilter is turn on, the + insert row just
add a blank row. It lost all default value and formulas. It works fine when I
turn AutoFilter back off.
Has anybody get this problem before? How do you handle it?
I really appreciate your help.
Thank you very much