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?