+ Reply to Thread
Results 1 to 3 of 3

vba to list Workbook & Sheet Statistics

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    United States
    MS-Off Ver
    Excel 365
    Posts
    8

    vba to list Workbook & Sheet Statistics

    Hi,

    I came across this sheet in an older file that lists the statistics of each sheet in the workbook. The data points include the used range, # of cells with conditional formatting, data validation, formulas, empty, constants, as well as the calc time for each sheet. This would be super helpful for troubleshooting problematic workbooks. My googling was unable to turn up any code that could either generate statistics by sheet, yet alone reproduce this. Does anyone have code that could generate this or some version of it?

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2021
    Location
    Norfolk, UK
    MS-Off Ver
    Excel 2003, 2007, 2013, 2019
    Posts
    215

    Re: vba to list Workbook & Sheet Statistics

    I have tried to message you privately (twice) but don't seem to be getting through.

    I have built an Excel Add-In that seems to cover at least some of your requirements, in terms of generating sheet/workbook level statistics.

    Sorry if this sounds at little unhelpful, but I must avoid being accused of self-promoting. Let me know if you would like more information.
    Regards,

    Stephen

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    United States
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: vba to list Workbook & Sheet Statistics

    Last edited by excelgeekgirl; 07-27-2022 at 04:57 PM. Reason: text still won't show

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Injuries Statistics sheet
    By Mohsinz in forum Excel General
    Replies: 3
    Last Post: 04-01-2017, 04:01 AM
  2. Replies: 5
    Last Post: 10-28-2015, 07:55 PM
  3. Replies: 1
    Last Post: 07-20-2012, 06:55 AM
  4. trying to use sheet CodeName to list all sheet names in a workbook
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 12:06 PM
  5. Reporting summary statistics into a new workbook
    By trungbui in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2010, 06:00 PM
  6. Excel workbook statistics
    By Mike Winqvist in forum Excel General
    Replies: 1
    Last Post: 11-29-2007, 05:20 PM
  7. How do I create a spread sheet for tracking batting statistics?
    By Robert in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-04-2006, 03:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1