Further clarification
Create a new workbook. Create a chart on its own sheet. Place the ChartSheet
after Sheet1.
Insert these 4 macros into a new module. run them and observe the results.

Sub CountWkShts()
MsgBox Worksheets.Count
End Sub

Sub CountShts()
MsgBox Sheets.Count
End Sub

Sub WkShtsName()
MsgBox Worksheets(3).Name
End Sub

Sub ShtsName()
MsgBox Sheets(3).Name
End Sub

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