View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mjgoo142@yahoo.com.au is offline
external usenet poster
 
Posts: 4
Default How to hide rows in a range that have a certain value, withoutfiltering

Hi All,
How can I hide all rows in a range that have a certain value eg
"93/94"
and then hide those entire rows only.
Sort of like Find all instances of the value then EntireRoe.Hide
I don't want to use filtering as the spreadsheet is intricate and I
think filter coding might upset the structure.
Thank you