+ Reply to Thread
Results 1 to 6 of 6

Insert empty/blank rows

  1. #1
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Insert empty/blank rows

    Hi all,

    Is it possible with a macro to insert 200 empty rows if the value in column A is higher than 1 million?

    Who can help me with this?

    As an example, I have added an attachment.

    Regards,

    Danielle
    insert empty rows.xlsx

  2. #2
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Brentwood, TN
    MS-Off Ver
    Excel 2007 at home/2010 at work
    Posts
    228

    Re: Insert empty/blank rows

    Sure it is.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Brentwood, TN
    MS-Off Ver
    Excel 2007 at home/2010 at work
    Posts
    228

    Re: Insert empty/blank rows

    ^^^ This above post assumes that you want the value in cell A1 to be greater than 1 million before inserting the rows. What do you mean by
    if the value in column A is higher than 1 million

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Insert empty/blank rows

    Hi,

    One way

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Insert empty/blank rows

    And another

    Please Login or Register  to view this content.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  6. #6
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Insert empty/blank rows

    Hi all,

    Thanks for the solutions.

    This is what I mean.

    Thanks,

    Greetings,

    Danielle

+ 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. Deleting Blank/empty rows
    By Pigggy in forum Excel General
    Replies: 5
    Last Post: 03-05-2012, 05:32 PM
  2. insert two empty rows below used data
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2010, 05:49 AM
  3. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM
  4. insert 1 empty row after 100 rows
    By vinz20k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2007, 03:52 AM
  5. Macro To Insert Empty Rows??
    By rtidrtid in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 11:20 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