Sub addRows()Dim lRow& With ActiveSheet For lRow = .UsedRange.Rows.Count To 1 Step -1 If .Cells(lRow, 1).Value > 0 Then .Rows(lRow + 1 & ":" & lRow + .Cells(lRow, 1).Value).Insert Shift:=xlDown Next End WithEnd Sub