The worksheets collection contains only worksheets.
The sheets collection contains worksheets and chartsheets. It also contains
any macro sheets and dialog sheets from xl 4 & xl5.

So, using worksheets is more specific.

--
tj


"Dennis" wrote:

Yes I have. It is the "in most cases" that I am trying to understand. I was
hoping that I could get more background as to why one would use Sheets() vs.
Worksheets().

Thanks Dennis

"tjtjjtjt" wrote:


with "Sheets" can I use either an:
Alpha variable or
"Actual W/S Name"
(1) for Sheet1

Have you tried any of these?

In most cases, you can avoid Selecting or Activating altogether.

For instance
Sheets(3).Copy Befo=Sheets(1)


--
tj


"Dennis" wrote:

Using 2003

First, when is it necessary to:

Activate(to ultimately Select)Worksheets(myWorksheet).Select
must I first do .Worksheets(myWorksheet).Activate
then .Worksheets(myWorksheet).Select
then .Worksheets(myWorksheet).Copy

which approach is better?

must I first do .Sheets(myWorksheet).Activate
then .Sheets(myWorksheet).Select
then .Sheets(myWorksheet).Copy

with "Sheets" can I use either an:
Alpha variable or
"Actual W/S Name"
(1) for Sheet1

What about Workbook(myWorkbook).Activate before
myWorkbook.Worksheets(myWorksheet).Activate
myWorkbook.Worksheets(myWorksheet).Select