I'm using this macro to hide all the rows in the range that
have a value of zero in the amount column. It's very slow!!
Is there any way to speed it up?
For i = 375 To 14 Step -1
myVal = Range("D" & i).Value
If myVal = 0 Then
Rows(i).EntireRow.Hidden = True
Else: End If
Next i
Thanks,
Crystal Khan
Oklahoma City
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|