VB: Find blank row then add another blank row

  • Thread starter Thread starter Tbal
  • Start date Start date
T

Tbal

:eek: I have a fairly large spreadsheet wherein there are multiple row
of related data separated by single blank rows. I need VB code tha
will find each of the blank rows and then add another blank ro
adjacent to it so that I will have a total of 2 blank rows between eac
set of related data. Any suggestions would be greatly appreciated
 
The following worked in Excel 2000 (one line fits all)
Caution - if there is more than one blank row between , it will insert
multiple rows.

change the range to fit your workbook.

Range("C1:C9").SpecialCells(xlCellTypeBlanks).EntireRow.Insert
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB: How do I find next blank row then add another blank row 1
Eliminate blanks while copy row and transpose 11
VB Add a blank row? 6
Code To Insert Blank Rows 5
Problem with deleting blank rows or last row 4
Insert row after blank cell encountered 6
Delete Blank Excel Rows 2
Deleting Blank Rows at end of sheet 6

Back
Top