Thread
:
How do I write a macro that hides a row based on data in Excel?
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
...
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson