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?