Macro to Copy & Paste

**juliorevka** · 03-06-2012, 02:53 PM

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.

Please Login or Register  to view this content.

**DGagnon** · 03-06-2012, 03:02 PM

you droped one " after P10, added it in bellow, give it a run.

Please Login or Register  to view this content.

**juliorevka** · 03-06-2012, 03:08 PM

It's not that, but I ended up figuring it out. I needed to paste onto the sheet rather than the selection.

But now I have another problem. I want to loop through every worksheet, and copy & paste formulas on every tab. But I get a "select method of range class failed" error.

Please Login or Register  to view this content.

**DGagnon** · 03-06-2012, 06:11 PM

you need to select the worksheet before you can select a range within the sheet, try this:

Please Login or Register  to view this content.

**DGagnon** · 03-16-2012, 10:31 PM

Is your issue resolved? If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.