Copy and insert row

Hi,

I want to copy current row and insert below.
Only formulas (and eventually formatting) should be copied.
It works fine but the problem is that values are copied too.

My code is

Please Login or Register  to view this content.

I found another thread from 2007 with similar problem but that code is completely different and I don't know how to combine these two codes.

Please Login or Register  to view this content.

Can anyone please help me to extend the code to remove values and only keep the formulas?

Thank you Kaper, this works fine!

Just one more thing. To make my file work for other users as well without the need of the Developer bar or quick commands - is it possible in any way to run this macro by a hyperlink?

I will try to upload my spreadsheet to make it clearer what I mean. In column A I have the code ="+" (must have it as a formula so the + won't disappear with the insert row macro).
I planned this to be used as a hyperlink to the macro but I really can't find any good solution on the web.

You made my day Kaper!

It really works! Thank's a lot!

But now I need to spread reputation to others before I can reputate you more ;-)