+ Reply to Thread
Results 1 to 6 of 6

Inserting Rows Between Two Columns (EntireRow doesn't work)

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Inserting Rows Between Two Columns (EntireRow doesn't work)

    Hello,

    I'm trying to create a macro that will insert rows between D46 and L46 but not anywhere else. When I use EntireRow, it does just as its name implies and inserts an entire row in the spreadsheet which pushes everything to the bottom.

    Is there any way to tell Excel to only insert rows between columns?

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Inserting Rows Between Two Columns (EntireRow doesn't work)

    How many rows?
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Re: Inserting Rows Between Two Columns (EntireRow doesn't work)

    Just one at a time, they will always insert in D46 to L46. It's meant to show a timeline of events in list format so the newest will be at the top.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Inserting Rows Between Two Columns (EntireRow doesn't work)

    See next code
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Re: Inserting Rows Between Two Columns (EntireRow doesn't work)

    Worked perfectly, thank you!

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Inserting Rows Between Two Columns (EntireRow doesn't work)

    It was not too difficult.
    Be free to ask for any improvement: Entering the nb of rows ...

+ 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. Script doesn't work anymore (auto hide rows and columns
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2013, 02:17 AM
  2. Adding columns doesn;t work
    By edwardag in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-25-2012, 11:18 AM
  3. Replies: 1
    Last Post: 02-23-2012, 02:12 PM
  4. Inserting Rows Doesn't Adjust Formula on Summary Page
    By Big_Tater in forum Excel General
    Replies: 1
    Last Post: 04-20-2010, 05:50 AM
  5. Range.Value doesn't work in hidden columns
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2006, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1