3,888 questions
Run error 1004 in Microsoft Excel
杉浦 裕美(Sugiura, Hiromi)
0
Reputation points
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
Sign in to answer