Run error 1004 in Microsoft Excel

杉浦 裕美(Sugiura, Hiromi) 0 Reputation points
2023-10-25T01:13:09.17+00:00

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
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,695 questions
0 comments No comments
{count} votes