+ Reply to Thread
Results 1 to 3 of 3

Very long time to calculate the VBA

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Very long time to calculate the VBA

    Hello,
    Please help to optimize the excel attached.
    When i insert a Date in column A from Sheet IESIRI, there is a VBA that launch a sort and Unique, and put the result in column E from sheet Sheet1.

    There is a lot of CPU consuming and I dont know why, and what trigger this.
    Please help optimizing.

    Also please look that Sheet1!E is connected to other cells in IESIRI.

    Thank you in advance.

    PS. You can post the modified XLS as is free for any other use.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-05-2014
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Very long time to calculate the VBA

    No ideea? Anyone?

  3. #3
    Registered User
    Join Date
    05-05-2014
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Very long time to calculate the VBA

    C'mon guys....a little help...

+ 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. Arrey formula taking long time to calculate - any other way or MACRO can be built ??
    By kedarlimaye87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2013, 08:44 AM
  2. Replies: 0
    Last Post: 07-24-2013, 04:35 PM
  3. Replies: 2
    Last Post: 04-10-2013, 11:17 AM
  4. Frequency Formula takes long time to calculate
    By janetp3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-18-2010, 05:15 PM
  5. Replies: 2
    Last Post: 04-05-2006, 01:00 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