Copy Row Info Up VBA Macro

The VBA macro below used to copy all info, formatting and formulas up one row after inserting that row. Now it inserts the row, copies the formatting but not the data.

Can anyone help with this one. I cannot determine what changed to make this happen.

It appears to be related to only one worksheet, I've placed this in personal.xlsb as I use it quite often in all my worksheets.


Sub COPYROWINFOUP()

With Selection.EntireRow
.Copy
.Insert
End With
Application.CutCopyMode = False
End Sub

Maybe:

Please Login or Register  to view this content.

It works in other worksheets though, can't figure out why in one particular worksheet it doesn't is all.

Can you attach a file with a few sheets and a sheet where it does not work? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.