View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_7_] Edwin Tam[_7_] is offline
external usenet poster
 
Posts: 94
Default Range = print area? to unhide rows.

ActiveSheet.Cells.EntireRow.Hidden = False

Regards,
Edwin Tam


"StargateFan" wrote:

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