| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting Rows
What are some commands to insert a row with VBA -- Tar ----------------------------------------------------------------------- Taru's Profile: http://www.excelforum.com/member.php...fo&userid=3549 View this thread: http://www.excelforum.com/showthread.php?threadid=55368 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inserting Rows
Try these: Rows("1:1").Select Selection.Insert Shift:=xlDown or Selection.EntireRow.Insert HTH -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=553684 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inserting Rows
You anc take any range and expand it to encompass the entire row and then
just insert. here are a few examples... Sub TestInsert() Dim rng As Range Set rng = Range("A2") rng.EntireRow.Insert Range("A4:C6").EntireRow.Insert Range("9:9").Insert End Sub -- HTH... Jim Thomlinson "Taru" wrote: What are some commands to insert a row with VBA? -- Taru ------------------------------------------------------------------------ Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494 View this thread: http://www.excelforum.com/showthread...hreadid=553684 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inserting Rows
if that wasn't enough try this...
Rows("1:10").Insert Die_Another_Day Jim Thomlinson wrote: You anc take any range and expand it to encompass the entire row and then just insert. here are a few examples... Sub TestInsert() Dim rng As Range Set rng = Range("A2") rng.EntireRow.Insert Range("A4:C6").EntireRow.Insert Range("9:9").Insert End Sub -- HTH... Jim Thomlinson "Taru" wrote: What are some commands to insert a row with VBA? -- Taru ------------------------------------------------------------------------ Taru's Profile: http://www.excelforum.com/member.php...o&userid=35494 View this thread: http://www.excelforum.com/showthread...hreadid=553684 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
| Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
| Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
| Why is inserting rows throwing off my hidden rows | Excel Programming | |||
| Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
![Taru[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
