Results 1 to 7 of 7

Copy specific range to offset location

Threaded View

Mister P Copy specific range to offset... 01-21-2009, 01:56 AM
JBeaucaire Try this instead: Sub... 01-21-2009, 03:28 AM
Mister P JB Tried your code and yes... 01-21-2009, 03:52 AM
JBeaucaire That second example doesn't... 01-21-2009, 04:27 AM
Mister P JB I'm not explaining this... 01-21-2009, 05:15 AM
DonkeyOte How about: Sub copy()... 01-21-2009, 05:35 AM
Mister P Works great 01-21-2009, 07:29 AM
  1. #1
    Registered User
    Join Date
    01-13-2009
    Location
    Prince Rupert, BC
    MS-Off Ver
    Excel 97, 2003
    Posts
    54

    Copy specific range to offset location

    I would appreciate some ones help to correct a macro I'm trying to write. The macro copies 3 columns from Sheet1 to Sheet2 in a selected location. The 3rd column copied needs to be pasted in a different column in Sheet2.

    Sheets("Sheet1").Select
    Range("A2:A10, G2:G10, H2:H10").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    Above copies Columns A, B & H (ranges) from Sheet1 and pastes to A, B & C columns in Sheet2 or depending on what cell was selected in Sheet 2 (1st, 2nd & 3rd columns). The requirement is to to have H pasted to Sheet2 F (6th column).

    I have tried several Target.Offset statements but have had no success. I've attached my sample sheet with what I have so far.

    Thanks in advance
    Attached Files Attached Files
    Last edited by Mister P; 01-21-2009 at 07:31 AM.

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