Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to line up rows
Hi,
Please help: How do I write a macro that will line up the rows if for example cells A5 = D7. That is, if cell A5 is the same as cell D7, then I want to: Range("A5:C6").Select Selection.Insert Shift:=xlDown I want to do this for all values in column A starting with A5. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to line up rows
On Sep 14, 4:53*am, missy wrote:
Hi, Please help: How do I write a macro that will line up the rows if for example cells A5 = D7. That is, if cell A5 is the same as cell D7, then I want to: * * Range("A5:C6").Select * * Selection.Insert Shift:=xlDown I want to do this for all values in column A starting with A5. Thank you. "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
macro from columns to rows but adding every time a new line | Excel Discussion (Misc queries) | |||
I need a macro for inserting a border line every 20 rows | Excel Discussion (Misc queries) | |||
My rows are off by one row, ie. data on line 10 should line up wi. | New Users to Excel | |||
Macro problem on, Yellowed line - previous line or next line. | Excel Programming |