Select range from active cell

**[email protected]** · 09-22-2010, 10:55 AM

Me again, Gurus.

I'm trying to copy a range of cells, starting with the active cell plus 2 columns to the right of the active cell. Here's what I've got, and every variation I could think of, but nothing seems to work:

Please Login or Register  to view this content.

Thanks in advance, again, for any help you can offer.

**deadlyduck** · 09-22-2010, 11:08 AM

Does this do it:

Please Login or Register  to view this content.

**Andrew-R** · 09-22-2010, 11:09 AM

You were *so* nearly there.

Please Login or Register  to view this content.

**romperstomper** · 09-22-2010, 11:12 AM

Or:

Please Login or Register  to view this content.

**Andrew-R** · 09-22-2010, 11:22 AM

Bloody minimalists...

Please Login or Register  to view this content.

**StephenR** · 09-22-2010, 11:26 AM

Declare each variable on a separate line and it will make your code look longer.

**[email protected]** · 09-22-2010, 11:29 AM

Sooooo close. I swear I thought I had tried that.

One last question. Now I need to past that range down the sheet, to the last row. I'm trying to select the range to paste the formulas to. Here's what I've got, but as usual, it's not working:

Please Login or Register  to view this content.

Sorry to be such a pain.

**romperstomper** · 09-22-2010, 11:34 AM

Missing quote mark before the O

**[email protected]** · 09-22-2010, 11:42 AM

I always miss the simplest stuff. Thanks, Stomper, again.

Andrew, that's hilarious. I'm gald you didn't send me THAT code to tre to select the range. I would've just given up completely. :-)

Have a good one, all.