Results 1 to 6 of 6

Copy range, offset, then paste

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2008
    MS-Off Ver
    2003 suite
    Posts
    64

    Copy range, offset, then paste

    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
    Last edited by WillysK5; 03-11-2009 at 11:58 AM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1