VBA Code to Get the count of all sheets in an Excel Workbook Sometime I come across with Excel reports with numerous worksheets / tabs. Sometimes you can't find the starting or ending of the workbook. Whenever I see those kind of Excel reports, I always wonder how many sheets will be there in that workbook !

You can count the number of values in a range or table by using a simple formula, clicking a button, or by using a worksheet function. Excel can also display the count of the number of selected cells on the Excel status bar. See the video demo that follows for a quick look at using the status bar. VBA Code to Get the count of all sheets in an Excel Workbook Sometime I come across with Excel reports with numerous worksheets / tabs. Sometimes you can't find the starting or ending of the workbook. Whenever I see those kind of Excel reports, I always wonder how many sheets will be there in that workbook !