How do I have Excel autohide ranges basted on conditions?

Posted to microsoft.public.excel.programming

gocush[_29_] gocush[_29_] is offline

external usenet poster

Posts: 252

How do I have Excel autohide ranges basted on conditions?

Yes. try something like this

sub HideRange()

If Range("A1")=True Then 'or whatever your condition is
Range("MyRange").EntireRow.Hidden = True 'or EntireColumn
End If
End Sub

"Derek" wrote:

Does anyone know if there is a way to have Excel autohide rows or ranges
based on selected conditions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Count functions with multiple conditions/ranges	kEV	Excel Worksheet Functions	3	July 21st 08 12:43 PM
Print Ranges based on conditions	Courtney	Excel Discussion (Misc queries)	0	July 16th 08 06:04 PM
sum of multiple ranges andmultiple conditions...	Herman56	Excel Discussion (Misc queries)	2	January 31st 06 09:19 PM
Excel, in a cell, how do i link to a pic & autohide like a comment	harperma	Excel Discussion (Misc queries)	1	October 26th 05 08:07 PM
COUNTIF Statement with Multiple Conditions in Different Ranges	KJA	Excel Worksheet Functions	2	April 26th 05 05:14 PM

All times are GMT +1. The time now is 06:55 AM.

Menu

About Us