Please help with these two Macro, add hidden cell in target row

[sfs4c03]

Hi

I have a macro to automatically copy last row's formula to the new row. It will work even I have hidden some columns with formula

Please Login or Register  to view this content.

It works good until I added a combobox for autofilter. Both Macro work well when I used in different workbook. But when I put it together (same worksheet).
An error comes out with the above macro: that command cannot be used on multiple selections - I discovered those hidden columns are no longer able to select and copy.

The autofilter I used are as follow

Please Login or Register  to view this content.

Please advise how should I fix this issue

Thank you
Patrick

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

[sfs4c03]

Does anyone has any idea?? or how can I including hidden cell in this line.

Rows(Target.Row - 1).Copy Rows(Target.Row)