| 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. |
| 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 | |||
![missy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
