Inserting row with formula and formatting from above row

[fride360]

I've been searching for a long time now and cannot find an answer to what I'm trying to do. I want a macro to insert a row below the selected cell and copy the formulas and formatting from the selected row. I've found some that do the formula but not the formatting.

Thanks!

[rollis13]

To copy formulas you probably found some like this:

Please Login or Register  to view this content.

but if you need the formatting too use one after the other:

Please Login or Register  to view this content.

But the most would be:

Please Login or Register  to view this content.