| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insertting multiple rows
I wrote about this yesterday, but I cannot find the message today...
ws.Rows(j + 1).EntireRow.Insert i - 1 Is there a waym, besides a for-loop, to insert multiple rows in one step? WBR Sonnich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insertting multiple rows
JE McGimpsey posted the following answer to your previous post:-
ws.Rows(j + 1).Resize(i - 1).Insert regards, OssieMac "Sonnich Jensen" wrote: I wrote about this yesterday, but I cannot find the message today... ws.Rows(j + 1).EntireRow.Insert i - 1 Is there a waym, besides a for-loop, to insert multiple rows in one step? WBR Sonnich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| need to replicate insertting a row from 1 worksheet into another | Excel Discussion (Misc queries) | |||
| Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
![Sonnich Jensen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
