+ Reply to Thread
Results 1 to 2 of 2

Huge difference in timing of performance of the same VBA code

  1. #1
    Registered User
    Join Date
    11-11-2019
    Location
    Warsaw, Poland
    MS-Off Ver
    2016, 32bit
    Posts
    5

    Huge difference in timing of performance of the same VBA code

    Hi,
    I am facing a problem I pursue to clarify.
    I have a VBA code below which deletes all the sheets in the workbook withou certain specifically named.
    Sometimes this code does the work in 3 sec removing around 300 sheets, sometimes it does it in 50 sec for the same number sheets.
    Any hunch what the heck causes that?

    Please Login or Register  to view this content.
    Last edited by Mariusz(); 11-11-2019 at 03:25 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Huge difference in timing of performance of the same VBA code

    Hi, welcome to the form.
    Please place your code in code tags (read the forum rules if you do not know how)

    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Run VBA code before huge calculations
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2015, 11:55 AM
  2. Replies: 1
    Last Post: 07-29-2014, 08:26 AM
  3. loop vs. simple function, huge difference in speed, why?
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-22-2010, 04:33 AM
  4. Finding difference in timing between transactions
    By bvarne1 in forum Excel General
    Replies: 12
    Last Post: 10-13-2009, 12:23 PM
  5. formula for timing difference
    By kaustubhghag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2008, 09:46 AM
  6. Timing code executions?
    By deeppurple247 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2007, 07:16 AM
  7. Timing code executions?
    By deeppurple247 in forum Excel General
    Replies: 1
    Last Post: 02-27-2007, 05:28 AM

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