| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Improve speed of the routine
Hallo,
since I have a dynamic range and sometimes the range is only a few rows and to be able to print all in one A4 sheet, I would like to hide the empty rows: Sub Minus() Dim cell As Range For Each cell In Range("G10:G150") cell.EntireRow.Hidden = (cell.Value = "") Next cell End Sub it works but it is very slow. Is there a way to improve the speed. Thanks and Regards Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I improve processing speed of macro | Excel Programming | |||
| Improve the speed of copy-paste | Excel Programming | |||
| Using an Array instead of a Vlookup to improve speed | Excel Programming | |||
| How can I Improve query speed? | Excel Programming | |||
| Howto Improve speed? | Excel Programming | |||
Threaded Mode
