Posted to microsoft.public.excel.programming

cchubba

external usenet poster

Posts: 2

Conditional Hide Rows Macro

colofnature wrote:
Try this:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case ucase(Range("a1").Value)
case "YES"
[20:23].entirerow.hidden = true
case else
[20:23].entirerow.hidden = false
End Select
End Sub

Col

--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=548938

That works great! Thanks

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
Using VBA to Conditional Hide Rows?	PBJ	Excel Discussion (Misc queries)	1	February 16th 07 06:54 PM
Conditional macro to hide rows	cher	Excel Programming	1	April 21st 05 06:23 PM
Conditional macro to hide rows	Rob	Excel Programming	0	April 21st 05 05:39 PM
Conditional Hide rows with zero	Vlookup help	Excel Programming	2	February 4th 05 09:41 PM
Conditional hide rows macros	Stu[_4_]	Excel Programming	1	September 25th 03 10:05 PM

All times are GMT +1. The time now is 07:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us