![]() |
|
#1
|
||||
|
||||
![]()
Try:
Code:
Sub Demo() Application.ScreenUpdating = False Dim lRow As Long, lCol As Long, i As Long, j As Long With ActiveWorkbook.ActiveSheet.UsedRange lRow = .Cells.SpecialCells(xlCellTypeLastCell).Row lCol = .Cells.SpecialCells(xlCellTypeLastCell).Column For i = lRow - 1 To 2 Step -1 If .Range("B" & i + 1).Value = 0 Then ElseIf .Range("B" & i).Value = 0 Then Else j = .Range("B" & i + 1).Value - .Range("B" & i).Value - 1 If j > 0 Then .Range(.Cells(i + 1, 1), .Cells(i + j, lCol)).Insert Shift:=xlShiftDown End If End If Next j = Format(.Range("B2").Value, "dd") If j > 1 Then .Range(.Cells(2, 1), .Cells(j, lCol)).Insert Shift:=xlShiftDown End If End With Application.ScreenUpdating = True End Sub For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] Last edited by macropod; 07-01-2015 at 05:53 AM. Reason: Minor Code Revision |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
Join cells together separated by ; when some are blank | leemoreau | Excel | 3 | 11-03-2013 11:22 AM |
![]() |
apolloman | Excel | 6 | 08-24-2011 05:38 AM |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |