Thread: How do I determine how many worksheets a workbook has at a glance
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I determine how many worksheets a workbook has at a glance
dm

Sub sheets_num()
MsgBox ActiveWorkbook.Sheets.Count & " sheets in workbook"
End Sub


Gord Dibben MS Excel MVP

On Mon, 5 Mar 2007 11:12:51 -0800, dm wrote:

Received an inquiry by a supervisor who would like to know how many
worksheets a workbook has without actually paging through the workbook to
determine how many there are. Is there a way it can be shown at a glance how
many worksheets a workbook has?

Reply With QuoteReply With Quote