View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StargateFan[_3_] StargateFan[_3_] is offline
external usenet poster
 
Posts: 171
Default Range = print area? to unhide rows.

I need to have a button that programmatically unhides any row or rows
users have hidden manually. The archives yield variations of this
type of code:

Range("A1").EntireRow.Hidden = False

I need something a lot more simple along the lines of

ActiveSheet.EntireRow.Hidden = False

something that will just take the activesheet and/or print area and
unhide any rows users need to have hidden before within that range.

Thanks. :oD