+ Reply to Thread
Results 1 to 5 of 5

Copy variable number of rows

  1. 09-27-2016, 08:09 PM #1
    potga
    potga is offline
    Registered User
    Join Date
    06-23-2014
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    45

    Copy variable number of rows

    Want to copy the block of non empty rows that start at A26. Number of rows after A26 is variable.
    In the example sheet want to copy everything in A26:A30.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-27-2016, 08:27 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy variable number of rows 

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 09-27-2016, 08:27 PM #3
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy variable number of rows

    Hi potga,

    This will copy the dynamic range to the clipboard (you didn't say where you wanted the range copied to):

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
  4. 09-27-2016, 08:40 PM #4
    potga
    potga is offline
    Registered User
    Join Date
    06-23-2014
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    45

    Re: Copy variable number of rows

    Thanks
    Just what I was after.
    Reply With QuoteRegister To Reply
  5. 09-27-2016, 10:40 PM #5
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: Copy variable number of rows

    On behalf of AlphaFrog and myself, you're welcome. Thanks also for the rep and marking the thread as solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to cut and paste a variable number of rows to a variable location?
    By TheClaw2323 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2015, 07:57 AM
  2. Macro to insert a variable number of rows into a variable location
    By TheClaw2323 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2015, 05:31 AM
  3. Macro to copy data into a variable number of rows
    By catb05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2015, 05:19 PM
  4. sort variable length column for min value--number of rows is variable
    By dloe in forum Excel General
    Replies: 6
    Last Post: 04-14-2012, 04:07 AM
  5. Copy a variable number of rows and columns to last row of another worksheet
    By SSGMiami in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2011, 10:46 AM
  6. Copy a variable number of rows
    By satishkhatri in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2008, 07:52 AM
  7. Copy cells to variable number of rows
    By Acct Supr - DCTC in forum Excel General
    Replies: 3
    Last Post: 11-14-2005, 01:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1