Hi All -

I need a macro that will copy the existing row let's say A10 to the next row A11 - FORMULAS AND ALL. Here is the catch the row it just copied should remain, but it needs to remove the formulas from it. It just needs to retain the values that are currrently in the cells.

Anyone ever encountered such a task?

thanks