LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Area as dynamic range? Michael.Tarnowski Excel Worksheet Functions 1 March 8th 09 04:02 PM
Excel2000:How to link Print Area with a named range Arvi Laanemets Excel Worksheet Functions 5 April 8th 08 02:35 PM
Print area/range Mike D. Excel Discussion (Misc queries) 2 June 30th 05 07:07 PM
Hide, Print, Unhide Rows pfosz Excel Programming 1 November 23rd 04 09:44 PM
Identify and Delete all Rows and Columns NOT in Print Area Keith Young[_2_] Excel Programming 6 December 4th 03 04:36 PM


All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"