Copy range, offset, then paste

**WillysK5** · 03-10-2009, 06:06 PM

Hello,

I'm trying to copy a range, specified by an offset, then PasteSpecial that range to yet another location specified by an offset.

This is the code I have so far, which does not attempt to find the range to copy via an offset. But I need it to do that eventually.

    ActiveWorksheet.Range("V3:AE3").Copy
    ActiveRange.Offset(6, 0).Select.PasteSpecial Paste:=xlFormulas

In this code, it should be copying the range V3:AE3, then pasting the formulas in the same columns, 6 rows below. Right now, I'm getting an error highlighting the first row. I would assume it's just the syntax, but I don't know....

I've searched upside and down, seen a bunch of different examples, but none seem to do this. (At least to these noob eyes...)

Thanks!
Willys

**StephenR** · 03-10-2009, 06:12 PM

Yes, there's no such thing as Activeworksheet.

With ActiveSheet.Range("V3:AE3")
    .Copy .Offset(6)
End With

**WillysK5** · 03-10-2009, 06:17 PM

Ha!

Thank you very much Stephen.

Can you help me with making the selected range offset from the active cell?

EDIT: Actually, the copy range can always be "A3:AE3", it's the paste that needs to be offset from the active cell.

**StephenR** · 03-10-2009, 06:37 PM

My pleasure. Try this.

Range("V3:AE3").Copy ActiveCell.Offset(6)

**bobwilko** · 03-11-2009, 07:42 AM

I was looking for something very similar but I need to paste special just the values into the offset range. My original range has formulas in. What would the code for that be please?

thanks

Bob

**WillysK5** · 03-11-2009, 10:55 AM

Thanks again Stephen!

And bobwilko, I'm going to go way out on a limb and attempt to help. Disclaimer: My username should probably be something like "soopervbanoobarific" or something along those lines.

Looking around yesterday for a solution to my problem, I found this:

    Sheet1.Range("A1:A200").Copy 
    Sheet1.Range("A1:A200").PasteSpecial xlPasteValues

Hope that helps, even a little...

Copy range, offset, then paste

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Copy range, offset, then paste

Re: Copy range, offset, then paste

Re: Copy range, offset, then paste

Re: Copy range, offset, then paste

Re: Copy range, offset, then paste

Re: Copy range, offset, then paste

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions