Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row code
Hi all
what's the VBA command to insert a row in a worksheet? Worksheets().Rows().InsertRow ? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row code
worksheets("sheet1").rows(3).entirerow.insert
-- Gary "glenn" wrote in message ... Hi all what's the VBA command to insert a row in a worksheet? Worksheets().Rows().InsertRow ? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row code
Gary: When using Rows you don't need to use entirerow. It can simply be
worksheets("sheet1").rows(3).insert entirerow or entire column is only need when you don't have the whole row or column such as Range("A1:C1") or cells(5,"C") "Gary Keramidas" wrote: worksheets("sheet1").rows(3).entirerow.insert -- Gary "glenn" wrote in message ... Hi all what's the VBA command to insert a row in a worksheet? Worksheets().Rows().InsertRow ? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row code
thanks, i usually use the entirerow.insert so when i'm reviewing code it's easy
to see it's inserting a row. i've never heard of it causing a problem, it's just for visual purposes. -- Gary "Joel" wrote in message ... Gary: When using Rows you don't need to use entirerow. It can simply be worksheets("sheet1").rows(3).insert entirerow or entire column is only need when you don't have the whole row or column such as Range("A1:C1") or cells(5,"C") "Gary Keramidas" wrote: worksheets("sheet1").rows(3).entirerow.insert -- Gary "glenn" wrote in message ... Hi all what's the VBA command to insert a row in a worksheet? Worksheets().Rows().InsertRow ? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Code | Excel Worksheet Functions | |||
How to insert code | Excel Discussion (Misc queries) | |||
Where to insert code? | Excel Programming | |||
Insert Code | New Users to Excel | |||
code to insert add'l code ??? | Excel Programming |