+ Reply to Thread
Results 1 to 2 of 2

is there a way for the cpu to work lighter with this macro?

  1. #1
    Registered User
    Join Date
    03-11-2005
    Posts
    87

    is there a way for the cpu to work lighter with this macro?

    Have this simple macro pushing the CPU to 100% capacity for few seconds, almost crashing the pc all the time it runs. I cant understand if the calculations are too heavy (doubt it: the cells copied from are heavy on formulas but the machine got plenty of power) or if there is a way to make the instructions even simpler. any idea/suggestions?
    Best
    BC


    Private Sub Worksheet_Calculate()

    If Range("O15") <> "" Then
    If Range("Q17").Text = "yes" Then
    Range("O19") = Range("P15")
    Range("O20") = Range("Q20")
    Range("P19") = Now
    End If
    End If

    If Range("Q24").Text = "yes" Then
    Range("O19") = ""
    Range("O20") = ""
    Range("P19") = ""
    End If


    End Sub

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    If I am not wrong, I think it depends on the number of calculations you have in your current sheet. So for every calculation, this event is triggered.

    The solution, identify for what calculations / event you want this event to be triggered.

    - Mangesh

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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