Insert row code
 

Hi all

what's the VBA command to insert a row in a worksheet?

Worksheets().Rows().InsertRow ?



thanks

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

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

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