Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having difficulty with the following code. If I remove the first 'IF'
statement regarding the comparison to < 1500, it runs fine (ie, quickly), but inserting it causes the routine to take about 1 minute to run ... forever in my world ... and I can't figure out why it's causing such a delay. I don't have to have the code built this way, but I've pulled it out into it's ow separate section and the result - slow run time - persists. Any help is greatly appreciated. Brett Private Sub Worksheet_Change(ByVal Target As Range) With Me If Intersect(Target, .Range("FROI_Vol"), .Range("SROI_Vol"), ..Range("MSR_Vol")) Is Nothing Then If .Range("Total_Vol").Value < 1500 Then .Range("AutoTrigger_Impl_Fee") = 0 Else If .Range("Total_Vol").Value < 501 Or RenewProduct.Value = True Then PT_Yes.Enabled = False PT_No.Enabled = False PT_No.Value = True Else PT_Yes.Enabled = True PT_No.Enabled = True PT_No.Value = True End If End If End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy-Paste function takes forever | Excel Discussion (Misc queries) | |||
Find Replace takes forever | Excel Discussion (Misc queries) | |||
ActiveSheet.Paste takes FOREVER!! | Excel Programming | |||
Excel takes forever to shut down | Excel Programming | |||
Calculating Time in XP takes forever | Excel Discussion (Misc queries) |