Posted to microsoft.public.excel.programming

CTInt04

external usenet poster

Posts: 4

Selecting two ranges of unadjacent cells

Problem:
I have a list of all the dates in the year. I want to hide all of the dates that are not May. I want to hide all the dates before and after May. How do I hide all the dates except May using a macro in VB.

Note: Specific cells cant be hidden, because the position of the dates in May might change. I can make a For...Next loop that does this, but it hides each row one by one, and takes tooooooo long.

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
Selecting mutliple ranges	Scott Graft	Excel Worksheet Functions	4	June 13th 08 08:36 PM
V.B selecting ranges for naming	ice_cool[_2_]	Excel Programming	2	March 5th 04 02:21 PM
Selecting ranges with a text box	Bob Metzler	Excel Programming	0	September 22nd 03 04:47 PM
Selecting Named Ranges	Ian[_8_]	Excel Programming	7	September 22nd 03 03:32 PM
selecting ranges	MDC	Excel Programming	1	July 24th 03 03:34 PM

All times are GMT +1. The time now is 03:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us