excel 运行时错误1004范围类的pastespecial方法失败

fhity93d 于 2023-04-13 发布在其他

关注(0)|答案(1)|浏览(201)

请帮助当我使用这个作为宏...有错误的问题...

Sub Working()
If IsEmpty(ActiveCell.Value) Then
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= \_
xlNone, SkipBlanks:=False, Transpose:=True
End If
If Not IsEmpty(ActiveCell.Value) Then
MsgBox "I'm not empty!"
End If
End Sub

错误代码为blowIf IsEmpty(ActiveCell.Value) Then Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= \_

excel

来源：https://stackoverflow.com/questions/75991292/runtime-error-1004-pastespecial-method-of-range-class-failed

1条答案

按热度按时间

5lhxktic1#

Sub Working()

If IsEmpty(ActiveCell.Value) Then 
   Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ 
     xlNone, SkipBlanks:=False, Transpose:=True 
Else 
   MsgBox "I'm not empty!"
End If

End Sub

赞(0）回复(0）举报 2023-04-13

我来回答

excel 运行时错误1004范围类的pastespecial方法失败

1条答案

相关问题

热门标签

最新问答