Thread: Modify code to hide rows based on the contents in a cell.
View Single Post
  #3  
Old 06-18-2009, 10:07 PM
dcgrove dcgrove is offline
Forum Contributor
  
Join Date: 16 Feb 2008
Location: Mansfield, TX
Posts: 196
dcgrove is becoming part of the community
Re: Modify code to hide rows based on the contents in a cell.
Thanks Leith! How would I make this search the contents of one particular cell instead of the word "Solar"? My goal is to have a data validation list that the user selects a word from and the macro will hide all rows without that word in them. You could use cell H3 as the cell the list is in if you need to.


Thanks!
Clayton
Last edited by dcgrove; 06-19-2009 at 07:13 PM.
Reply With Quote