Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why should the following (supposedly simple piece of) code run so slowly:-
Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Application.EnableEvents = False For Each mycell In Range("C11:K11,M11:U11") If mycell.Value = "" Then mycell.Offset(32).Value = "" ElseIf mycell.Value = 0 Then mycell.Offset(32).Value = 0 End If Next MsgBox "End" Application.ScreenUpdating = True Application.EnableEvents = True End Sub Thanks Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow code | Excel Programming | |||
very slow code | Excel Programming | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming | |||
Slow Code | Excel Programming | |||
SLOW Code... | Excel Programming |