RunTime error 424 (Object require)

[jchan58]

Hi, I'm struggling to fix this error. I'm trying to copy a cell value from one worksheet to another within the same workbook. here is the code:

Sub try()
Worksheets("Temp_Provider").Range("BZ2").Copy
Worksheets("ManualTemplate").Range("K3").PasteSpecial Paste:=xlPasteValues (this is where the error appears)

End Sub

Please help what is missing! Big thanks

 

[pvr928]

Hi jchan58

Perhaps try:

Worksheets("ManualTemplate").Range("K3").Value2 = Worksheets("Temp_Provider").Range("BZ2").Value2

Cheers

pvr928

 

[jchan58]

Hi jchan58

Perhaps try:

Worksheets("ManualTemplate").Range("K3").Value2 = Worksheets("Temp_Provider").Range("BZ2").Value2

Cheers

pvr928

Thank You!!