| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create macro to add 8 rows at a time?
You're absolutely right! Insert rows example below...
Range(ActiveCell.Row() & ":" & _ ActiveCell.Offset(7, 0).Row).Insert _ Shift:=xlDown -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "StumpedAgain" wrote: My guess is that you're only inserting a row for a particular cell. Try this: Range("B5").EntireRow.Insert shift:=xlDown -- -SA "GM" wrote: I have a worksheet with data that I need to insert 8 rows inbetween the other rows in a spreadsheet. I tried creating a Macro but it records the cell reference and just adds 8 rows at the same spot. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a macro to delete multiple rows? | Excel Discussion (Misc queries) | |||
| Create a macro to delete rows if value is less than a specified nu | Excel Worksheet Functions | |||
| how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
| Create a Macro that will copy the rows that have a value < 0 | Excel Discussion (Misc queries) | |||
| HOW DO I CREATE A MACRO TO STRIP OUT ROWS? | Excel Discussion (Misc queries) | |||
![Gary Brown[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
