+ Reply to Thread
Results 1 to 4 of 4

Need macro to copy and paste in specific row.

Hybrid View

  1. 06-09-2016, 11:09 AM #1
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Need macro to copy and paste in specific row.

    Hi all,

    Please help me for the below criteria.

    1. Copy the entire row (A14) from Sheet 1 and paste it in the sheet 2 in C14.
    Reply With QuoteRegister To Reply
  2. 06-09-2016, 11:31 AM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,027

    Re: Need macro to copy and paste in specific row.

    If you use "entirerow.copy" in VBA, you must paste it starting in column A of any sheet. You cannot paste it starting in column C. Your best bet is to copy and paste the range in Sheet1.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 06-09-2016, 11:43 AM #3
    Revathi kannan
    Revathi kannan is offline
    Forum Contributor
    Join Date
    06-01-2015
    Location
    Chennai,India
    MS-Off Ver
    Microsoft Office 2021
    Posts
    146

    Re: Need macro to copy and paste in specific row.

    oops sorry its my blunder.. Got your point.. Thanks a lot.. I have modified my code based on your comments. Now it is working fine..
    Reply With QuoteRegister To Reply
  4. 06-09-2016, 11:44 AM #4
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,027

    Re: Need macro to copy and paste in specific row.

    Glad it worked out.
    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] No Experience – Need a specific copy and paste macro
    By shuynh84 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2014, 03:15 PM
  2. Macro to copy paste specific charts and ranges to PPT
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-02-2014, 06:07 AM
  3. Macro to copy and paste at specific time of day
    By BCrawford in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2013, 06:27 AM
  4. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  5. [SOLVED] Macro Copy Paste specific cells
    By guydixon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2012, 01:16 AM
  6. macro that will go to a specific webpage,copy and paste
    By Billy Dee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2010, 11:49 AM
  7. Copy paste Macro, Finding a specific value.
    By itsnick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2009, 03:53 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