What is the difference between using .active vs .select and when does one use
one versus the other, and why?

I'm not sure you asked the question you meant to. The .Active property
applies to the ListObject object whereas the .Select property doesn't. You
probably meant the .Activate property. While the Select method can apply to
lots of things (but not the ListObject object), I presume you are asking
about these methods as they apply to a cell or range of cells. The VB help
files for the Select Method says this in its Remarks section...

"To select a cell or a range of cells, use the Select method.
To make a single cell the active cell, use the Activate method."

When in doubt about something, you should consider checking the help files.

--
Rick (MVP - Excel)


"Rick" wrote in message
...
What is the difference between using .active vs .select and when does one
use
one versus the other, and why?

I guess I should have paid attention to your subject line before I answered
your posting.<g Dave has given you the answer to your question,

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
I'm not sure you asked the question you meant to. The .Active property
applies to the ListObject object whereas the .Select property doesn't. You
probably meant the .Activate property. While the Select method can apply
to lots of things (but not the ListObject object), I presume you are
asking about these methods as they apply to a cell or range of cells. The
VB help files for the Select Method says this in its Remarks section...

"To select a cell or a range of cells, use the Select method.
To make a single cell the active cell, use the Activate method."

When in doubt about something, you should consider checking the help
files.

--
Rick (MVP - Excel)


"Rick" wrote in message
...
What is the difference between using .active vs .select and when does one
use
one versus the other, and why?

Try grouping multiple sheets, then activating a different one of those
grouped/selected sheets.

You'll see that the sheet grouping stays, but the activesheet is different.

It's similar to selecting a cell and activating a cell.

If you select a range of cells (say A1:E10), then activate a cell in that
selection, the selection stays the same, but the activecell changes.

In code:

Range("a1:e10").Select
Range("c5").Activate

vs

Range("a1:e10").Select
Range("c5").Select



Rick wrote:

What is the difference between using .active vs .select and when does one use
one versus the other, and why?

--

Dave Peterson