+ Reply to Thread
Results 1 to 3 of 3

Alternate Blank Row in excel spreadsheet

  1. #1
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Alternate Blank Row in excel spreadsheet

    Dear Experts ,

    I need some assistance here

    I basically have attached 2 excel sheets .One input and one output
    The input sheet will show a normal spreadsheet with filled rows .

    What i want is to have alternate blank rows matching the width of the row above for as many rows in the sheet .
    This process starts from row 2 because i don't want a blank row after row 1 , but i need for all other rows i.e row 2 will have below it a blank row having same width and height as row 2 , row 3 will have a row below having same width and height as row 3 and onwards till there is content available in any of the rows


    Thanks for your time and would be grateful for assistance ,

    Humble regards ,

    Amlan
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Alternate Blank Row in excel spreadsheet

    hi, amlan009, option, please check attachment, run code "test" (press ALT+F8, select "test", press Run button)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-26-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    154

    Re: Alternate Blank Row in excel spreadsheet

    Sir , this works like a dream ,

    Thanks so so so so so so so so so much !!!!!!!!!!

    I will do it in my test sheet which has a million rows

    Also i will mark the thread as solved !

    Thanks again

    Hug's ,

    Amlan

+ 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. Inserting alternate blank rows in Excel
    By KopRed in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 10:10 PM
  2. alternate blank row
    By bayanbaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 03:05 AM
  3. [SOLVED] alternate blank row
    By bayanbaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] alternate blank row
    By bayanbaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 AM
  5. alternate blank row
    By bayanbaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2005, 11: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