Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is a macro that I use to insert blank lines after the value in Column A
changes. I need to be able to select which column I want the macro to evaluate. I am thinking that an input box is the easiest way, but do not know how to do it. Thanks! Sub InsertRows() Dim cRows As Long Dim i As Integer For i = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1 If Cells(i, "A") < Cells(i + 1, "A") Then Cells(i + 1, "A").EntireRow.Insert End If Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nedd to change column headings from numbers back to letters | New Users to Excel | |||
I nedd help setting up a database on my customers | Excel Discussion (Misc queries) | |||
I nedd my autofill options to always default to "copy cells" | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Nedd help on my function in VBA | Excel Programming |