How do I write a macro that hides a row based on data in Excel?
 

How do I write a macro that hides a row based on data in Excel?
 

JJO

You should include your question in the body of your post and use the
subject line to show the subject. It makes it easier for others to read.
Here's an example of a macro that hides a row based on the value of a cell.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 Then 'only for column A
If Target.Value = "HideMe" Then
Application.EnableEvents = False
Target.EntireRow.Hidden = True
Application.EnableEvents = True
End If
End If

End Sub

For more on events, see here
http://www.dicks-blog.com/archives/2...ng-vba-events/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

JJO wrote:

How do I write a macro that hides a row based on data in Excel?
 

Try something like

If Range("A1").Value 100 Then
Rows(3).Hidden = False
Else
Rows(3).Hidden = True
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JJO" wrote in message
...

How do I write a macro that hides a row based on data in Excel?
 

You can write something like:

If activecell = <your parameters then Selection.EntireRow.Hidden =
True

Tim


--
TimZ
------------------------------------------------------------------------
TimZ's Profile: http://www.excelforum.com/member.php...o&userid=23558
View this thread: http://www.excelforum.com/showthread...hreadid=373865