Insert row code

[glenn]

Hi all

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

Worksheets().Rows().InsertRow ?



thanks

 

[Gary Keramidas]

worksheets("sheet1").rows(3).entirerow.insert

 

[Guest]

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]

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.