Macro No Longer Working- Run-time error 80010108

[RGee]

I have been using a spreadsheet that friend made a few years ago that has a macro embedded in it. This past week, Excel has updated to a newer version and now I am receiving a Run-Time error message and am unable to run the macro.



Here is the Runtime Error:

When I click on "Debug", I'm brought to the Macro code and this part is highlighted:

(If the image is too small, the part highlighted reads "Selection.PasteSpecial Paste:=xlPasteValues, Operation:xlNone, SkipBlanks _ :=False, Transpose:=False")



I'm assuming that something in this part of the code is no longer compatible with the most recent Excel update. Any ideas on how to tweak this code so that I can run the macro?



Thanks in advance.

 

[Anthony47]

The only suggestion I can give you is to publish the code of the macro, from Sub XXX to End Sub