+ Reply to Thread
Results 1 to 3 of 3

Insert New Row

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Insert New Row

    Hello,

    I need a macro please.
    I wanted to see if its possible to insert new row after the last entry in between row A3:A23 with a message box ?how many rows you want to insert??.

    Also the rows setting to insert in between A3:A23 on the last entry height with 30.

    Let say that the A3, A4, A5 and A6 had an entry and I deleted A4, A5 then I need to insert 2 new rows but it should insert from the last entry A6, so the new row should inserted after A6.

    Thank you.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Insert New Row

    Hello RJ1969
    Are they from same requirement?
    https://www.excelforum.com/excel-pro...-settings.html
    If yes, keep going with that thread.
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Insert New Row

    Hi Bebo
    I was thinking to separate the button for inserting the new rows but I think the other scenario work perfectly.

    Thank you so much.

+ 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. Vba that moves cells with text, (up and to left, insert row/ insert copied cell)
    By sergi117 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2018, 03:12 PM
  2. Replies: 5
    Last Post: 08-30-2017, 01:52 PM
  3. Macro insert multiple sheet and insert age band based on numbers
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-01-2017, 01:47 PM
  4. [SOLVED] Enable the Insert icon in Developer tab > Controls > Insert in Excel 2010
    By pedapudipradeep in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2014, 12:41 PM
  5. Replies: 6
    Last Post: 10-02-2014, 06:31 AM
  6. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  7. Help - Insert method of Range class failed - Selection.Insert Shift:=xlToRight
    By sandy@excelforum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2012, 11:14 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