Error Message = Microsoft Excel cannot paste the data (Run-time error '1004')

[WallisAggie646777]

The following 6 lines of code are contained in a worksheet Command button in the "Weekly" worksheet
When I click on the command button, the cannot paste error occurs.

With Sheets("Groups")
.Range(wsGroups.Cells(MonR, GroupC), wsGroups.Cells(GroupFriR + 4, GroupEndC)).Copy '
End With
wsWeekly.Activate ' "Weekly" worksheet
Range("A40").Select
ActiveSheet.Pictures.Paste(Link:=True).Select :The cannot paste error occurs on this line of code.

I can set a breakpoint on the line of code causing the error and then click on the Command button.
Execution stops on the line where the error occurred. I then use F8 to Step into to execute the line of code and it works by pasting the data as expected

In summary, with no breakpoint, the code fails when clicking on the Command button, but with the breakpoint, I can click on the Command button and then use F8 to step into the line of code and the code pastes the data as expected.

 

[Kenneth Hobson]

No problem, we have a few more tricks to try. So you click the button on Test worksheet and it erred? If so, you have something else really odd going on.

Looking at possible reasons, I "trust" that you have trusted macros and VBA access?

1. Open a blank workbook in Excel.
2. Go to File > Options > Trust Center
3. Click on Trust Center Settings...
4. Under Macro Settings, make sure Trust access to the VBA project object model is checked.

Some other reasons might be conflicting AddIn. You should disable all and then try my workbook's button.

Could be a corrupted template file but let's leave that for last.