Posted to microsoft.public.excel.programming

Ruan[_3_]

external usenet poster

Posts: 33

Hiding Rows with Formulas

Hello

I have an IF statement in Range("B9:B1000"), which either displays a value
or a blank cell. How do I hide the rows, if the result in this range is a
blank cell? The below formula doesn't work.

Sub HideRows()

With Range("B9:B1000")
.EntireRow.Hidden = False
.SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End With
Range("B9").Select
End Sub

Thanks
Ruan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HIDING FORMULAS	zen	Excel Discussion (Misc queries)	3	July 1st 08 09:25 PM
Color alternate rows when after hiding selected rows	Monk[_2_]	Excel Worksheet Functions	6	June 7th 08 01:36 AM
Hiding Specific Rows Based on Values in Other Rows	Chris	Excel Worksheet Functions	1	November 2nd 06 08:21 PM
Hiding a button when hiding rows	fergusor	Excel Discussion (Misc queries)	2	August 10th 06 02:31 PM
Hiding Rows if the linked rows are blank	KG	Excel Discussion (Misc queries)	9	May 18th 05 02:32 AM

All times are GMT +1. The time now is 12:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us