Hi all

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

Worksheets().Rows().InsertRow ?



thanks

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

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

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