How do I know how many worksheets are in a workbook?

Method One

(1) Open the Tools menu and select the macro Visual Basic Editor command:

(2) In the Open window, select "Insert" → "module" command:

(3) Enter the following content:

Sub Sheetcount ()

Dim Num as Integer

Num=thisworkbook.sheets.count

Sheets (1). Select

Cells (=num)

End Sub

(4) To run the macro, the number in cell A1 of the first sheet in the workbook is the number of worksheets.

　Method Two

(1) Press "CTRL+F3" key to open the "Define name" dialog, define an X, enter "=get.workbook (4)" at "Reference location", then click the "OK" button:

(2) In any cell input "=x", the result is the number of worksheets.

　　Method Three

Entering =info ("Numfile") cell properties in any cell is a general view of the number of worksheets that open all Excel files.

How do I know how many worksheets are in a workbook?