What is a difference between sheet and worksheet?

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hello,
There are 2 properties one can select:
..ActiveWorkbook.Worksheets()
and
..ActiveWorkbook.Sheets()

What is a difference?
Jack
 
Jack said:
Hello,
There are 2 properties one can select:
.ActiveWorkbook.Worksheets()
and
.ActiveWorkbook.Sheets()

What is a difference?
Jack
Click to expand...

Hi Jack,

Sheets includes ChartSheets, Worksheets doesn't.

Ken Johnson
 
Can we all play?

Sheets include Excel 5 Dialog Sheets, Worksheets don't.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Bob said:
Can we all play?

Sheets include Excel 5 Dialog Sheets, Worksheets don't.

--

HTH

Bob Phillips
Click to expand...


Thanks Bob.
Game Over?

Ken Johnson
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Sheets or Worksheets 2
Stay on Active Sheet 2
Can't delete sheets 8
Excel crashes and restarts when accessing newly created worksheet 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Ron de Bruin - Merge cells from all worksheets 0
Copy Template with Updated Values Each Time 0

Back
Top