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
Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.