Do Not Activate Sheet

[User Name Active]

The following code copies the formulas in row 9 and pastes the formulas in row 10 down to a row determined by a cell. The formula works great with one catch. I am on a completely different sheet when I run this code and the "activate line keeps taking me to this sheet when I don't want it to. I tried changing it to
Sheets("Customer").Rows("9").Copy, but it doesn't work that way. Someone help please.

Sub CopyFormulas_Customer()
 Dim i As Long
 i = Sheets("Restructure").Range("H1").Value
 Sheets("Customer").Activate
 Rows("9").Copy
 Rows("10:" & i).PasteSpecial
 Application.CutCopyMode = False
 End Sub

 

[Scott Huish]

Does this do what you want?

Sub test()
With Sheets("Customer")
    .Rows(9).Copy .Rows(10).Resize(Sheets("Restructure").Range("H1"))
End With
End Sub

 

[User Name Active]

Yes it does! Thank You!