Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert two lines each time a value in Column L changes
I am trying to get Excel to insert two lines each time a value in Column L
changes. My code is below: Dim rngB As Range Set rngB = Range("L2") While rngB.Value < "" If rngB.Value < rngB.Offset(1).Value Then rngB.Offset(1).Resize(2).EntireRow.Insert Set rngB = rngB.Offset(1) End If Set rngB = rngB.Offset(1) Wend It works the first time, but then fails afterwards. Is this one of those instances where you have to start from the bottom of the list and work up? I though working from the bottom up was only necessary for deleting rows based on some criteria, such as deleting rows with blanks. Any suggestions? Thanks a lot!! Ryan-- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Lines | Excel Worksheet Functions | |||
Insert lines in more than one worksheet at a time... | Excel Worksheet Functions | |||
insert lines | Excel Discussion (Misc queries) | |||
Insert lines when x< y | Excel Programming | |||
how to automatically insert blank lines in between non-blank lines | Excel Programming |