Why wouldn't this code work in a macro activated by a command button! It copies the cell to the clipboard but won't finish with the paste! Stumped!!
P.S. Button is on active cell sheet.

P.S. Button is on active cell sheet.
Code:
Worksheets("Sheet1").Range("N2").CopyActiveCell.PasteSpecial Paste:=xlPasteFormats
ActiveCell.PasteSpecial Paste:=xlPasteValues
Last edited: