+ Reply to Thread
Results 1 to 3 of 3

VBA find the time it takes to calculate worksheets

  1. #1
    Registered User
    Join Date
    03-31-2020
    Location
    Amsterdam, Holland
    MS-Off Ver
    2013
    Posts
    2

    VBA find the time it takes to calculate worksheets

    Hi,

    As workbooks tend to get slow when they they reach a certain size, I am currently trying to figure out a method to calculate which of the worksheets in my workbook take up the most time.
    I already have a method to find the size of the individual worksheets, but as an increased size does not necessarily mean it makes the worksheet slower I am trying to figure out if there is another way to calculate the speed of each individual worksheet.

    Any tips or help would be usefull.

    Thanks in advance.

    Kind regards.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: VBA find the time it takes to calculate worksheets

    Hi and welcome
    have you searched the Net? This problem has been solved one way or another in different instances

  3. #3
    Registered User
    Join Date
    03-31-2020
    Location
    Amsterdam, Holland
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA find the time it takes to calculate worksheets

    Thanks for the reply,

    I have, and I couldn't find what I was looking for. It's quite specific as I don't want to time how long it takes to run a certain code, or how big(in bytes) a sheet is. I want to find out how much each sheet individually contributes to how slow the total workbook becomes.

    Any tips would be appreciated!

    Kind regards,

+ 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. [SOLVED] Time Formula, time it takes to calculate
    By sans in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2023, 08:23 AM
  2. [SOLVED] Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-03-2014, 03:43 PM
  3. [SOLVED] Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  4. Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Excel takes along time to calculate
    By TonyL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-30-2005, 08:05 PM

Tags for this Thread

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