How do I have Excel autohide ranges basted on conditions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if there is a way to have Excel autohide rows or ranges
based on selected conditions?
 
Hi Derek,
YOu might spell out what you mean by "selected conditions." A value in a
cell, upon entering data ain a cell, whether the sun is shining?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autohide Rows based on condition 6
VBA Autohide Help 6
AutoHide 1
Changes in How Code Acts After Upgrade of Excel 2
Excel VBA 1
Assistance with VBA and drop down list 0
range naming and conditional creation 4
run a macro in excel when moving data 0

Back
Top