Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that someone can gave me. What I
am interested in is in Col G if the word 'total' appears and the cell below is NOT blank then insert three rows. There are 21 occurrences where the word 'total' appears and there is not a space below. What I get is 63 rows inserted at the top!! I hope this is not too hard to fix. Please help me with the fix. Thanks. Dim DataRng As Range Dim Cell As Range Set DataRng = Range("G1:G2000") For Each Cell In DataRng 'If cell value has the word 'total' in it and one row below current cell is blank then do something If (InStr(LCase(Cell.Value), "total") 0 And Len(Trim (Cell.Offset(1, 0).Value)) 0) Then Selection.EntireRow.Insert Selection.EntireRow.Insert Selection.EntireRow.Insert End If Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
inserting rows | Excel Discussion (Misc queries) | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Inserting Rows | Excel Discussion (Misc queries) |