Bulk Unhide

's Computer Specifications

Hi Folks,

I can find my last row of data with...

LastRowOfData = .Cells(.Rows.Count, "F").End(xlUp).Row
For X = 1 To LastRowOfData

But how can I then select rows 1 through LastRowOfData then unhide all at
once??

-Not that they are all hidden in the firstplace, but I think it would run
faster then looping through each row and unhiding it if it is hidden.

TIA,

Steve

's Computer Specifications

You can unhide all hidden rows in a worksheet with:

Rows.Hidden = False

"Stephen" wrote:

> Hi Folks,
>
> I can find my last row of data with...
>
> LastRowOfData = .Cells(.Rows.Count, "F").End(xlUp).Row
> For X = 1 To LastRowOfData
>
> But how can I then select rows 1 through LastRowOfData then unhide all at
> once??
>
> -Not that they are all hidden in the firstplace, but I think it would run
> faster then looping through each row and unhiding it if it is hidden.
>
> TIA,
>
> Steve

's Computer Specifications

No reason to select:

.Range("1:" & .Cells(.Rows.Count, 6).Row).EntireRow.Hidden = False

In article <B5646456-2331-4671-9C2C-(E-Mail Removed)>,
Stephen <(E-Mail Removed)> wrote:

> Hi Folks,
>
> I can find my last row of data with...
>
> LastRowOfData = .Cells(.Rows.Count, "F").End(xlUp).Row
> For X = 1 To LastRowOfData
>
> But how can I then select rows 1 through LastRowOfData then unhide all at
> once??
>
> -Not that they are all hidden in the firstplace, but I think it would run
> faster then looping through each row and unhiding it if it is hidden.
>
> TIA,
>
> Steve

's Computer Specifications

ok now I just feel dumb... that was too simple.

thanks, that's going to come in very handy!

"StumpedAgain" wrote:

> You can unhide all hidden rows in a worksheet with:
>
> Rows.Hidden = False
>
>
>
> "Stephen" wrote:
>
> > Hi Folks,
> >
> > I can find my last row of data with...
> >
> > LastRowOfData = .Cells(.Rows.Count, "F").End(xlUp).Row
> > For X = 1 To LastRowOfData
> >
> > But how can I then select rows 1 through LastRowOfData then unhide all at
> > once??
> >
> > -Not that they are all hidden in the firstplace, but I think it would run
> > faster then looping through each row and unhiding it if it is hidden.
> >
> > TIA,
> >
> > Steve

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to unhide rows....when they won't unhide	Mike C	Microsoft Excel Discussion	6	6th Oct 2008 10:05 PM
unhide row does not unhide the hidden rows	nikita	Microsoft Excel Worksheet Functions	4	24th May 2008 02:59 PM
non bulk emails going to bulk file	JMarie	Microsoft Outlook Discussion	1	3rd Jan 2008 04:58 PM
Unhide column - why doesn't click unhide column work?	=?Utf-8?B?SCBTdGV2ZW5z?=	Microsoft Excel Misc	1	15th Nov 2007 12:36 AM
how do i unhide a worksheet in excel 2003? unhide tab don't work	=?Utf-8?B?bWlrZWtlYXQ=?=	Microsoft Excel Misc	2	6th Mar 2006 03:36 AM