How to Count Sheets in Workbook using VBA – VBA Tutorials

Count Sheets in a Workbook
  • Save

Introduction/Problem Statement

In this blog, we will talk about How to Count Sheets in a Workbook using VBA code.



To Calculate Worksheet using VBA.

Calculate worksheet using VBA
  • Save

Sub KDataScience_HowToCountWorksheetInAWorkbook()

    'To count Worksheets in a Workbook
    MsgBox Application.Sheets.Count

End Sub

This is the code for counting the number of sheets in a Workbook.



this code which is used for counting the number of Sheets in a Workbook is very simple and easy to use. Our opinion, rather than to count sheets Number manually, use this code for your ease. I hope this will help you for clarification.


Don't miss out!
Subscribe To Newsletter

Get the latest Excel, VBA, Automation, Tips & Tricks, delivered straight to your inbox.

Invalid email address
Give it a try. You can unsubscribe at any time.


  1. I got this blog on the internet when I was searching for VBA codes and i found it very useful and effective. I really do appreciate the work and the detailed analysis you have done in the blog which really helps me to clarify my doubts and I will also suggest this website to others.

Leave a Reply

Your email address will not be published. Required fields are marked *

Copy link
Powered by Social Snap