| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro speed
The code shown below runs through about 6000 rows and takes 5 minutes or so
to sort the data and hide the rows. Does anyone know how to change this to make it run faster? Thanks for your help. Dim R As Range For Each R In Range("c7:c6210") If R.Value = "0" Then Rows(R.Row).Hidden = True If R.Value = "" Then Rows(R.Row).Hidden = True Next -- Rex Munn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to speed up this macro | Excel Programming | |||
| VBA macro speed | Excel Programming | |||
| can anybody speed up this macro | Excel Programming | |||
| Help, need to speed up this macro | Excel Discussion (Misc queries) | |||
| Speed-up a macro! | Excel Programming | |||
Threaded Mode
