Macro to Copy & Paste

[juliorevka]

I have a bunch of formulas in D10:P10 that I want pasted on a row specified by the user.

Note: theRow is a number that has already been specified by the user by working code.
The following code gives me an "object doesn't support this property or method" error.

Sheet1.Range("D10:P10").Select
Selection.Copy
Sheet1.Range("D" & theRow & ":P" & theRow).Paste