| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO INSERT ROWS
Hi, I have numbers in coloumn "A" (Please see below)
A 1 2 3 4 5 I want macro which should add 6 rows between those numbers which I mentioned above then put numbers back in sequense. For example macro should add 6 rows from row 2 in which I have number "2" in coloumn "A" cell 2 and once rows been added then there will be no numbers in those added rows coloumn "A" cells so macro should go in cell "A1" and put numbers back in sequense LIKE :- ADDED ROWS BY MACRO 1 2 row added row added row added row added row added row added 3 4 5 PUT NUMBER BACK IN SEQUENSE OR DRAG NUMBERS 1 2 3 4 5 6 7 8 9 10 11 Please if any body can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows macro. | Excel Discussion (Misc queries) | |||
| Insert Rows Macro | Excel Discussion (Misc queries) | |||
| asking again, macro to insert rows | Excel Worksheet Functions | |||
| Insert Rows Macro | Excel Programming | |||
| macro to insert rows. | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
