View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dummster
 
Posts: n/a
Default hide rows based on value in cell

How do I hide rows based on a specific value in a cell? Let's say if a user
enters the value "lucy in the sky with diamonds" in cell M48, then rows 44-50
should be displayed, if not, then hidden.