Thread: Hiding named ranges depending on a cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Hiding named ranges depending on a cell value
Hi Ctech,

Had a similar case ... following is working for me :
ActiveSheet.Range("A14:A18").EntireRow.Hidden = False

HTH
Cheers
Carim

Reply With QuoteReply With Quote