Show us the code that takes to long.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CTInt04" wrote in message
...
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.