+ Reply to Thread
Results 1 to 3 of 3

Copy and paste range using a variable

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Office 365
    Posts
    71

    Copy and paste range using a variable

    I am sure this is the simplest of questions, but I cannot for the life of me find the solution using Google nor ExcelForum search.

    My problem is more complicated, but boils down to this:

    Please Login or Register  to view this content.
    I have a range in a sheet I need to copy to another sheet. Since have multiple ranges to copy and do not want to go back and forth between sheets, I'd like to copy them into named variables. I would then like to paste this range into another worksheet, knowing the upper left corner I want.

    Anyone know how to do this simply? I keep getting errors!

    Thank You,


    GregersDK

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Copy and paste range using a variable

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy and paste range using a variable

    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy and Paste a Variable-Length Range
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2015, 12:46 PM
  2. [SOLVED] Copy and Paste Variable Range
    By massivemike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 09:34 AM
  3. [SOLVED] Copy/Paste Values from Variable Range to Corresponding Variable Range
    By Cpetersoc in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2012, 08:20 AM
  4. Variable range copy paste
    By scottsanpedro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 09:10 AM
  5. Excel07 VBA for Copy paste variable range
    By nsorden in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2009, 09:49 AM
  6. Variable to select range to copy and paste to
    By cecil23 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-30-2007, 02:35 AM
  7. [SOLVED] Copy/paste range variable between workbooks
    By Jim73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2005, 05:06 AM

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