Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Insert rows at every change in a column
hi,
I would like to know the Macro code for Inserting rows at every change in a given column Regards Macro man |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Insert rows at every change in a column
MMan,
Try the macro below, based on column D. To change that, change the line Set myRange = Range("D:D") to reflect your actual desired column. -- HTH, Bernie MS Excel MVP Sub TryNow() Dim myRow As Long Dim StrtRow As Long Dim myCol As Integer Dim myRange As Range Set myRange = Range("D:D") myCol = myRange.Column StrtRow = myRange(65536).End(xlUp).Row For myRow = StrtRow To 2 Step -1 If Cells(myRow, myCol).Value < Cells(myRow - 1, myCol).Value Then Cells(myRow, myCol).EntireRow.Insert End If Next myRow End Sub wrote in message ups.com... hi, I would like to know the Macro code for Inserting rows at every change in a given column Regards Macro man |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Insert rows at every change in a column
Hi Bernie,
Thanks a lot for giving me this code. its great!!!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Insert rows at every change in a column
hi Bernie,
Can you pls give me the code for defining the range through Input box for the code which you gave for "macro to Insert rows at every change in a column". Thanks Macro Man |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to Insert rows at every change in a column
Macro Man,
Set myRange = Application.InputBox(Prompt:="Select your range", Type:=8) HTH, Bernie MS Excel MVP wrote in message oups.com... hi Bernie, Can you pls give me the code for defining the range through Input box for the code which you gave for "macro to Insert rows at every change in a column". Thanks Macro Man |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
Function to insert rows on a change in a cell | Excel Discussion (Misc queries) | |||
insert column, rows, grayed out, help? | Excel Discussion (Misc queries) | |||
How to insert rows based on change in data | Excel Worksheet Functions | |||
Macro - Insert&Label Column, if the labeled column doesn't exist | Excel Programming |