Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB: Find blank row then add another blank row
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 -- Tba ----------------------------------------------------------------------- Tbal's Profile: http://www.excelforum.com/member.php...fo&userid=2531 View this thread: http://www.excelforum.com/showthread.php?threadid=38808 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find blank row then add another blank row
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).Enti reRow.Insert -- steveB Remove "AYN" from email to respond "Tbal" wrote in message ... I have a fairly large spreadsheet wherein there are multiple rows of related data separated by single blank rows. I need VB code that will find each of the blank rows and then add another blank row adjacent to it so that I will have a total of 2 blank rows between each set of related data. Any suggestions would be greatly appreciated! -- Tbal ------------------------------------------------------------------------ Tbal's Profile: http://www.excelforum.com/member.php...o&userid=25317 View this thread: http://www.excelforum.com/showthread...hreadid=388085 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
VB: How do I find next blank row then add another blank row | Excel Programming | |||
Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming |