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

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

Range = print area? to unhide rows.
 

On Wed, 22 Feb 2006 19:04:28 -0800, Edwin Tam
wrote:

ActiveSheet.Cells.EntireRow.Hidden = False

Regards,
Edwin Tam

Thank you, that seems to work perfectly! :oD

"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

Range = print area? to unhide rows.
 

On Thu, 23 Feb 2006 10:37:52 -0500, StargateFan
wrote:

On Wed, 22 Feb 2006 19:04:28 -0800, Edwin Tam
wrote:

ActiveSheet.Cells.EntireRow.Hidden = False

Yup, this works perfectly, thank you!

Was wondering if there is a way to get the cursor to move out of the
selected area once rows become hidden? I tried
ActiveCell.Offset(1, 0).Select, of course, but duh, it moves down one
cell _within_ the hidden selection and I only seem to be able to move
out of the hidden selected area by using the down arrow key. I then
modified the above to:

Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select

which works better but the ideal solution would be to do what the down
arrow does so that users are in the row below of what they've just
hidden after using ActiveSheet.Cells.EntireRow.Hidden = False. Is
there a way to do this? Again, googled the archives but I must not be
asking the right question.

Thanks!

Regards,
Edwin Tam

Thank you, that seems to work perfectly! :oD

"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