+ Reply to Thread
Results 1 to 3 of 3

copy rows with VBA function

  1. 05-28-2017, 11:56 AM #1
    faustfisher
    faustfisher is offline
    Registered User
    Join Date
    05-23-2017
    Location
    UK
    MS-Off Ver
    14.4.0
    Posts
    4

    copy rows with VBA function

    Hello,

    I am trying to copy all my rows in a single row (please see attached screenshot). I should be possible to do it in VBA but the code I wrote does not work:
    Range (A3: C5) Copy (From D2)

    Any suggestion?
    Thank you!
    Screen Shot 2017-05-28 at 11.48.30 AM.png
    Reply With QuoteRegister To Reply
  2. 05-28-2017, 12:50 PM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,218

    Re: copy rows with VBA function

    Can give this a go...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 05-29-2017, 10:31 PM #3
    mike7952
    mike7952 is online now
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: copy rows with VBA function

    Another way

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark 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. [SOLVED] VBA Split Cell Contents to New Rows & Copy Cells containing single values to the new rows
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-14-2017, 05:30 PM
  2. Macro copies rows based on condition, BUT rows copy in Wrong order. PLEASE HELP!
    By JAllard1990 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2014, 04:33 PM
  3. Multi Function Macro (copy/paste values based on criteria, delete/insert rows, printing)
    By jpouma1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2014, 12:28 PM
  4. [SOLVED] Identify duplicate rows and copy/Paste the first cell to all cells of equal rows
    By vs5 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2014, 06:31 AM
  5. Need function to count rows until trigger, use variable to specify cell range to copy
    By Iblis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2010, 01:53 AM
  6. VBscript function to copy rows from datasheet in qtp to an external excel sheet
    By laecy123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2009, 09:32 AM
  7. function/formula to copy/past multiple data rows in Excel worksheet
    By djerin in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-22-2009, 09:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1