Thread: Hiding Rows between two Finds
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Hiding Rows between two Finds
Range(rng1.offset(1,0),rng2.Offset(-1,0)).EntireRow.Hidden = True

but if you have outlining, you might want to perform the hide manually with
the macro recorder turned on and see if you can modify that.

--
Regards,
Tom Ogilvy

"SharonInGa" wrote in message
...
How can I hide rows between two labels?

Label 1
detail
detail
Label2


Reply With QuoteReply With Quote