Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the following macro set up but it keeps hanging up on the first
indented line. Sub Insertrow() ' ' Insertrow Macro ' Macro recorded 10/6/2005 by DCTC ' ' Keyboard Shortcut: Ctrl+i ' Dim iLastRow As Long Dim i As Long iLastRow = ActiveSheet.Cells(Rows.Count, "F").End(x1Up).Row For i = iLastRow To 1 Step -1 If Cells(i, "F").Value = "Total" Then Rows(i + 1).EntireRow.Insert End If Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to insert row after specific text | Excel Discussion (Misc queries) | |||
asking again, macro to insert rows | Excel Worksheet Functions | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
insert rows in excel spreadsheet via macro | Excel Worksheet Functions | |||
Macro not working with Excel 2003 | Excel Discussion (Misc queries) |