I need help how I can loop or repeat the following code!?
That is if the If sentece triggers then I want the code to continue to execute. It can be either a loop which loops certain amounts of time or endless as far as the If sentence triggers. Thought of "For ...Next" not sure!
If Cells(25, 9) = "UP" Then
Application.EnableEvents = False
Range("K25:L25").Select
Selection.Copy
Range("M25:N25").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("L9").Select
Thanks
Bern
That is if the If sentece triggers then I want the code to continue to execute. It can be either a loop which loops certain amounts of time or endless as far as the If sentence triggers. Thought of "For ...Next" not sure!
If Cells(25, 9) = "UP" Then
Application.EnableEvents = False
Range("K25:L25").Select
Selection.Copy
Range("M25:N25").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Range("L9").Select
Thanks
Bern