All of a sudden the 2nd part of this coede (where I Paste Special the last part) stopped working! The error i'm getting is "Run-time error '1004': PasteSpecial method of Range class failed
Any suggestions?
Sub Copy_Transpose_Paste_Prices()
'
' Copy & Paste Categories
'
Dim Last_Row5 As...