|Just like MIke, I am not having any trouble copying the formulas from Row 3 to a "new" Row 4.|
In addition, this appears to be a recorded macro. Quite often, a recorded macro produces code that is bloated and inefficient. For example, there is no need to "Select" an object in VBA in order to perform an action on it and there is no need to unhide a Row just to copy it.
As far as I can tell, this code does the same thing as the code that you posted, but
without all the extra (and unnecessary) steps.
4 instructions instead of 10
Rows("4:4").EntireRow.Hidden = False
Application.CutCopyMode = False
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.