+ Reply to Thread
Results 1 to 4 of 4

Marco to Insert & shift cells down at active cell and copy cell range

  1. #1
    Registered User
    Join Date
    10-08-2015
    Location
    Waco, TX
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Marco to Insert & shift cells down at active cell and copy cell range

    I have a scheduling spreadsheet that i constantly need to add more events to.
    I have a template of cells that i use for each event and am currently inserting 5 blank rows and then coping and pasting the template cells into the blank rows.

    I recently began using the marco below to copy the selected range at the active cell.

    Range("AB3:AP7").Copy Destination:=Cells(ActiveCell.Row + 1, 1)

    I would like to add the inserting and shifting cells down at the active cell to make this macro complete.

    Any help is greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Marco to Insert & shift cells down at active cell and copy cell range

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-08-2015
    Location
    Waco, TX
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Re: Marco to Insert & shift cells down at active cell and copy cell range

    Thank you so much. It works perfect!

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Marco to Insert & shift cells down at active cell and copy cell range

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. See link for guidance.

    http://www.excelforum.com/forum-rule...rum-rules.html

+ 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. Copy Active Cell Row and insert below Active Cell Row
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-09-2015, 02:40 PM
  2. Replies: 4
    Last Post: 07-03-2015, 04:27 AM
  3. Replies: 0
    Last Post: 03-26-2013, 02:58 PM
  4. [SOLVED] Insert Copied Cells multiple times, shift cell down
    By system in forum Excel General
    Replies: 18
    Last Post: 09-21-2012, 12:47 AM
  5. Insert Copied Cells multiple times, shift cell down
    By system in forum Excel General
    Replies: 1
    Last Post: 09-08-2012, 10:49 PM
  6. [SOLVED] insert cell and shift cells right at every blank cell in column
    By zmarsh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2012, 04:13 PM
  7. Marco to copy from active cell to top of column
    By Balthasar G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2006, 08:29 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