Thread: mark the last three rows in a names range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default mark the last three rows in a names range
Hi Ctech,

Go head with defining your condition and use :

ActiveSheet.Rows("7:10").EntireRow.Hidden = True
ActiveSheet.Rows("7:10").EntireRow.Hidden = False

HTH
Carim

Reply With QuoteReply With Quote