Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2007

Tip: Looking for answers? Try searching our database.

Something Wrong With Posting?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
davjoh123@yahoo.com - 23 Jan 2007 21:42 GMT
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
Ed - 23 Jan 2007 22:11 GMT
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

> 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
Greg Wilson - 23 Jan 2007 23:12 GMT
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



> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.