About a week ago I posted a request for help on Hiding Unused Rows.
There was no response to this. I am wondering if there is something
wrong with the way I posted this. I found the solution myself but there
may be other solutions.

Dave

Dave - IMO there's nothing wrong with your other post. I'm not an expert
here, so someone else may chime in, but I know I've written worse! When
that has happened to me, I just repost my question.

You may have incorrect assumptions about this newsgroup, though. There are
no paid moderators or staff. No one is one here 24/7. This is not a
registered on-line help forum. MVPs do not work for Microsoft (if they did,
we'd probably have a better application!). People come on this newsgroup as
they have time and inclination - some of them actually come here to do
nothing but help others. You may have just hit a lull in which no one felt
confident enough to answer your question. Also, if you look at the sheer
number of messages that post here in a day, it won't take long for any
message to get shoved down deep and buried. Very few people go looking for
that one lone unanswered post.

Cheers!
Ed

wrote in message
oups.com...
About a week ago I posted a request for help on Hiding Unused Rows.
There was no response to this. I am wondering if there is something
wrong with the way I posted this. I found the solution myself but there
may be other solutions.

Dave

One problem is that it is a mistake to post a follow-up to your own post
unless necessary because it looks as though someone already answered it.
Also, there are heavy hitters (MVP's and others) here and lesser mortals such
as myself that respond to posts. I am reluctant to respond if I think one of
the top-notch guys may respond because it may nix the OP's chance of getting
a better answer. So there can be a catch-22 and you may not get an answer.
Lastly, in reading your code, it looked like you know what you are doing and
are an equal or near equal to many who respond.

As for your code, a general comment is that you should try to avoid calling
worksheetfunctions in a loop if you can get VBA to do it because VBA must
call Excel each time to do the calculating. In a long loop this can be an
issue.

In a program of mine (http://tinyurl.com/ys3fbm) I have a long loop
containing this line:
v = Ar(a) + Ar(b) + Ar(c) + Ar(d) + Ar(e) + Ar(f) + _
Ar(g) + Ar(h) + Ar(i) + Ar(j)
Originally I used the Sum worksheet function but the above produced a
profound improvement in performance.

Regards,
Greg






" wrote:

About a week ago I posted a request for help on Hiding Unused Rows.
There was no response to this. I am wondering if there is something
wrong with the way I posted this. I found the solution myself but there
may be other solutions.

Dave