| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide rows not working
Sub hide_row()
For Each cell In Range("B6:B9") With cell If .Value < 1 Or .Value = "" Then .EntireRow.Hidden = True End If End With Next cell End Sub Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 16:39:01 -0700, CevaClerkII <Joel Zurba/NA/TNT/TPG@Logistics wrote: This is just what i've been looking for, but I also want blank cells included. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro/code to hide rows | Excel Worksheet Functions | |||
| Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
| Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
| hide rows with macro | Excel Discussion (Misc queries) | |||
| macro to hide rows | Excel Discussion (Misc queries) | |||
Threaded Mode
