+ Reply to Thread
Results 1 to 3 of 3

Macro Insert Row

  1. #1
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Macro Insert Row

    [SOLVED]

    randomly merged cell in the middle that was not shown and when selecting the row the column was merged to the bottom of the file causing it to select everything... sad sad


    I am trying to get a macro to insert a new row when it hits the selection.Insert instead of holding the row number it selects the entire document and inserts thousands of rows... can someone give me the simple fix for this issue...

    Please Login or Register  to view this content.
    Last edited by cory0789; 04-23-2014 at 02:44 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro Insert Row

    Hello cory0789,

    Obviously there is more going on here than these 2 lines. Please post the full Sub or Function procedure this code is part of.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Macro Insert Row

    Embarassingly [SOLVED]

+ 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. [SOLVED] Macro to insert row if cell(i,1) notequal cell(i,1)+1 and insert certain values in row.
    By mareike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 03:29 AM
  2. [SOLVED] Macro to copy row, insert below, invert amt, and insert blank row between each new tx
    By raquel1227 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2013, 12:56 PM
  3. Insert blank row, sum and insert page break macro
    By kim5012 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2012, 01:46 AM
  4. Macro: Copy Row and Insert it ; Insert Odd Year
    By buto87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2012, 08:55 AM
  5. [SOLVED] Macro to insert copy and insert formulas only to next blank row
    By bob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2006, 07:10 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