Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I write a macro that hides a row based on data in Excel?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Macro to Fix Data Alignment (Data dump from Crystal to Excel | Excel Discussion (Misc queries) | |||
Write a macro that hides rows based on empty cells | Excel Discussion (Misc queries) | |||
can I write an Excel macro to pause for data entry then continue? | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
macro - hides everything and not just certain columns as recorded | Excel Programming |