Posted to microsoft.public.excel.programming

Stephen[_24_] Stephen[_24_] is offline

external usenet poster

Posts: 83

Bulk Unhide

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
unhide row does not unhide the hidden rows	nikita	Excel Worksheet Functions	4	May 24th 08 02:59 PM
Bulk Upload	Kris	Excel Programming	0	July 17th 06 03:15 PM
how do i unhide a worksheet in excel 2003? unhide tab don't work	mikekeat	Excel Discussion (Misc queries)	2	March 6th 06 03:36 AM
Bulk row deletion	quartz[_2_]	Excel Programming	1	November 9th 04 05:00 PM
Bulk Email	Don Kline[_3_]	Excel Programming	1	August 31st 03 04:27 PM

All times are GMT +1. The time now is 06:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us