Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good morning group.
The below is a very useful macro to insert rows where the contents of column B change. How might it be modified so that it inserts rows where the contents of columns A and B change? Sub InsertRow_At_Change() Dim i As Long With Application .Calculation = xlManual .ScreenUpdating = False End With For i = Cells(Rows.Count, 2).End(xlUp).Row To 2 Step -1 If Cells(i - 1, 2) < Cells(i, 2) Then _ Cells(i, 1).Resize(1, 1).EntireRow.Insert Next i With Application .Calculation = xlAutomatic .ScreenUpdating = True End With End Sub Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding rows or columns based on cell contents | Excel Discussion (Misc queries) | |||
macro with input msg based on cell contents | Excel Discussion (Misc queries) | |||
Excel Macro to Insert the contents of one column to other | Excel Discussion (Misc queries) | |||
Insert Columns based on cell value | Excel Programming | |||
Macro to Sort Automatically Based on Contents of Drop-down Box | Excel Programming |