Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,695 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
After upgrading to v2309 and v2310, an execution error occurred in the linked image macro. The operation is as follows.
When the macro is executed, an error occurs in [Selection.Formula = ""].
error is 1004
but, v2308 is not error.
Sub Macro1()
'
' Macro1 Macro
'
'
Range("D3:H8").Select
Selection.Copy
Range("J3").Select
ActiveSheet.Pictures.Paste(Link:=True).Select
ActiveSheet.Shapes.Range(Array("Picture 1")).Select
Application.CutCopyMode = False
Selection.Formula = ""
Range("A1").Select
End Sub