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

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

I'd use:
activecell.entirerow.delete



Zone wrote:

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

Yes, that is better. Thanks, Dave
"Dave Peterson" wrote in message
...
The both do the same thing (but both are kind of convuluted to me).

I'd use:
activecell.entirerow.delete



Zone wrote:

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

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.
--
Regards,
Bill Renaud