EntireRow

[Zone]

What is the difference, if any, in these two statements?

rows(activecell.Row).delete
rows(activecell.Row).entirerow.delete

They seem to work exactly the same, but I see lots of posts that include the
EntireRow part, so I'm curious. James

 

[Dave Peterson]

The both do the same thing (but both are kind of convuluted to me).

I'd use:
activecell.entirerow.delete

 

[Zone]

Yes, that is better. Thanks, Dave

The both do the same thing (but both are kind of convuluted to me).

I'd use:
activecell.entirerow.delete

 

[Bill Renaud]

As an aside, note that:

activecell.delete

would delete just the single cell, just it would if you were doing this
from the user interface. Note that a dialog box will come up asking
whether you want to shift remaining cells up or to the left.

activecell.entirerow.delete

will, of course, delete the entire row, which is usually (but not
always) what is wanted.

If you did actually want to delete only the single cell, then you would
have to provide an additional argument to specify which way to shift the
remaining cells.