Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
do if loop
turn of the automaitic calculations
application.calclation = xlmanual 'Your code application.calculation = xlAutomatic end sub -- HTH... Jim Thomlinson "bozo the clown" wrote: I am trying to write a loop. If a condition is met then run the code and return back to the "do if" statement. I have one that works but it maxs out the cpu and is slow(see below). Is there anything better? Sub Time_set() If Range("A65536") < Range("A65536").Offset(0, 2) Then Range("A39999:AD39999").Select Selection.Delete Shift:=xlUp Range("C65536").Select ActiveCell.FormulaR1C1 = "=CURRENCIES!R[-65535]C" Range("D65536").Select ActiveCell.FormulaR1C1 = "=CURRENCIES!R[-65535]C[-2]" ActiveCell.Offset(0, -1).Range("A1:B1").Select Selection.Copy ActiveCell.Offset(0, -2).Range("A1").Select ActiveCell.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("E65535:AD65535").Select Selection.AutoFill Destination:=Range("E65535:AD65536"), Type:= _ xlFillDefault Range("E65535:AD65536").Select Else End If Application.OnTime Now + TimeValue("00:00:01"), "time_set" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Worksheet_Change - loop within a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |