Thread: Can visual basics hide rows based on cell values?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
  
Posts: 341
Default Can visual basics hide rows based on cell values?
Yes

If Range("B6").Value < 1 Then Range("B6").EntireRow.Hidden = True
--
Allllen


"Jerrypetch" wrote:

Can visual basics hide rows based on cell values? If for example a specific
cell has a value less than 1, then the entire row is hidden.
Reply With QuoteReply With Quote