Results 1 to 5 of 5

Copy and Paste a Variable-Length Range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Copy and Paste a Variable-Length Range

    Hi,

    I have a list of names in column A in Sheet1 and would like to copy them over to Sheet2, pasting them starting at A1.

    Can someone please tell me the code necessary to do this.

    Thanks
    Last edited by andrewc; 03-13-2015 at 12:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy range with variable length
    By Coleman34 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2014, 01:07 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. [SOLVED] Find/Copy Variable length range
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 03:55 PM

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