There was a line wrap problem. The original URL spanned two lines. Put it all
together and you'll get there (I did).

But you already found it (since you posted it in your reply.)

Are you sure you have empty cells in that range? Not formulas that evaluate to
"". They're not empty--they contain a formula. And not formulas that evaluated
to "" that were converted to values. These cells aren't empty either.

(I'm guessing it's one of these. If you post back with more details, you should
get a nice response.)

Stu wrote:

And
when I go on to:
http://google.com/groups?threadm=jem...71617102003%40

I get this message "Unable to find thread. Please recheck the URL."

--

Stu

----

"J.E. McGimpsey" wrote in message
...
Instead of reposting the same article as yesterday, why don't you
tell us what you didn't like about the responses you got. In
particular, this one works in less than a second for me:

http://google.com/groups?threadm=jem...71617102003%40
msnews.microsoft.com

In article ,
"Stu" wrote:

Hi,
Is there an way to speed up a macro, I have the following macro and it
takes
a bit of time to run and I want it to run fast if that is possible:

Sub Main()

Dim Rng As Range
For Each Rng In

Range("G3:G201,G203:G401,G403:G601,G603:G801,G803: G1001,G1003:G1201,G1203:G1
401,G1403:G1601,G1603:G1801,G1803:G2001,G2003:G220 1,G2203:G2401") '<<
adjust
for correct range
Rng(1, 1).EntireRow.Hidden = (Rng.Value = "")
Next Rng

End Sub

Any ideas appreciated.
---
Stu




--

Dave Peterson