sheets active vs select

[Rick]

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

 

[Rick Rothstein]

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.

 

[Dave Peterson]

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 Rothstein]

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,