Copying and pasting using VBA when not on that sheet

[Dscalf1]

I am trying to copy and paste information on another sheet that isnt the active sheet. Here is my code It is giving me the error on the first line and im not sure why.

Sub Copy_Paste()


    Sheets("Dough Information").Range("H3:J152").Select
    Selection.Copy
    Sheets("Dough Information").Range("K3").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    
End Sub

 

[Joe4]

You cannot select a range on a sheet if that is not the active sheet at the time.
However, you don't need to select it at all. Most "Select" statements can be eliminated, i.e.
combine these two rows:

    Sheets("Dough Information").Range("H3:J152").Select
    Selection.Copy

to just this:

    Sheets("Dough Information").Range("H3:J152").Copy

(you don't need to actually select a range first before copying it in VBA).

 

[mumps]

Try:

Sub Copy_Paste()
    With Sheets("Dough Information")
        .Range("H3:J152").Copy
        .Range("K3").PasteSpecial Paste:=xlPasteValues
    End With
    Application.CutCopyMode = False
End Sub

 

[Dscalf1]

Thank yall for all the information I did not know that!! mumps that code worked great! Thank You!

 

[mumps]

Glad we could help.