Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following to clear out 0 entries:
Dim cl As Range, myRange As Range Set myRange = Range("A2:BV2348") For Each cl In myRange.Cells If cl.Value = 0 Then cl.ClearContents Next cl Is there a way to make this faster or a different approach? This is taking more than 45 minutes, I don't know why. TIA DPingger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slow Macro | Excel Programming | |||
Help with slow Macro | Excel Programming | |||
slow macro | Excel Programming | |||
Macro help, very slow | Excel Programming | |||
Slow macro | Excel Programming |