| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Increment numerically ordered
Jim here is the code
Here is the code that copies and inserts the rows: Sub copyrows() numrows = InputBox("Number of rows") 'Rows(ActiveCell.Row).Copy ActiveCell.Resize(numrows) Rows(ActiveCell.Row).Copy ActiveCell.Resize(numrows).Insert Application.CutCopyMode = False End Sub Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Increment numerically ordered rows | Excel Discussion (Misc queries) | |||
| Automatically Increment Row Numbers | New Users to Excel | |||
| automatically increment y-axis daily | Charts and Charting in Excel | |||
| automatically increment field by one | Excel Discussion (Misc queries) | |||
| increment cell value automatically | Excel Worksheet Functions | |||
Threaded Mode
