Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding rows that meet multiple conditions in excel
This is my first time writing a VBA code (custom module). I want to learn how
to write a code that will ask excel to hide rows where a specific criteriia is met. For ex, " hide all rows where col C has the words 'network' in it". Or, can I write an if statement in excel to do this?? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding rows that meet multiple conditions in excel
Sub tst()
r = Cells(65500, 3).End(xlUp).Row For t = 1 To r If Cells(t, 3) = "network" Then Cells(t, 3).EntireRow.Hidden = True End If Next End Sub "KBV" skrev: This is my first time writing a VBA code (custom module). I want to learn how to write a code that will ask excel to hide rows where a specific criteriia is met. For ex, " hide all rows where col C has the words 'network' in it". Or, can I write an if statement in excel to do this?? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
how to copy multiple Excel files from Outlook into Excel??? | Excel Discussion (Misc queries) | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions | |||
Sum with multiple conditions in Excel 2000 | Excel Worksheet Functions |