Run-time error '1004':

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sub Button81_Click()
Range("E1.1.1_Final").Copy
Range("E1.1.1_Prioryr").PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("E1.1.1_Data").ClearContents

Range("E1.1.2_Final").Copy
Range("E1.1.2_Prioryr").PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("E1.1.2_Data").ClearContents

Range("F1.1.1_Final").Copy
Range("F1.1.1_Prioryr").PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("F1.1.1_Data").ClearContents

Range("F1.1.2_Final").Copy
Range("F1.1.2_Prioryr").PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("F1.1.2_Data").ClearContents

Range("F1.2.1_Final").Copy
 
Must likely, the size of the ranges is diffrent. For Example if your named
range E1.1.1_Final is 4 rows long and you are trying to paste to
E1.1.1_Prioryr which has 7 rows, you will get the Run-time error '1004'
To avoid that you have to make E1.1.1_Prioryr a one cell reference for
example A1 or resize the range where you are posting the source data.

Regards,

Michael Arch.
Please rate this posting.
 
Back
Top