JannetteChristie
Board Regular
- Joined
- Dec 14, 2015
- Messages
- 119
I have a button on a sheet with the following code, but am getting the following error message:
Error message is Run-time error '1004': PasteSpecial method of Range class failed
Can anyone help please?
Sub CopyDPSSP()
Dim InputRow
Worksheets("DPS-SP").Range("W2:BC2").Copy
InputRow = Application.InputBox(Prompt:="Which Input sheet row should this be copied to ? ", Type:=1)
On Error GoTo 0
If InputRow > 0 Then
Worksheets("Input Sheet").Range("E" & InputRow).PasteSpecial Paste:=xlPasteValues
Else
MsgBox "No row selected"
End If
End Sub
Error message is Run-time error '1004': PasteSpecial method of Range class failed
Can anyone help please?