+ Reply to Thread
Page 4 of 40 FirstFirst ... 2345614 ... LastLast
Results 46 to 60 of 590

Thread: The Bad Threads

  1. #46
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,212

    Re: The Bad Threads

    Even though it's not from our forum, I had to post this one. 150 lines of code, which I'm guessing the requestor didn't write a line of, and they just want to add a "Zone" as if that meant anything to the rest of us. And the user has over 900 posts there. Beautiful.

    http://www.mrexcel.com/forum/showthread.php?t=372929

  2. #47
    Registered User
    Join Date
    09-16-2004
    Posts
    88

    Re: The Bad Threads

    Heh! I reckon I've been guilty of a couple of these! Sorry!

    Best one I've seen recently was a thread where a guy asked a question. 10 minutes later, he posted an 'Anyone?' message. About 20 minutes after that, he posted 'I'm REALLY not happy with the lack of help I'm getting here!'

  3. #48
    Forum Guru mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,984

    Re: The Bad Threads

    Knocking a suggestion/reply is always a good respomse

    I am not familiar with the working with that function, so I don’t think that it will work

    http://www.excelforum.com/excel-prog...ro-to-run.html
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  4. #49
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    MS 2007
    Posts
    4,972

    Re: The Bad Threads

    LOL Mudraker. That one is a classic.
    ChemistB
    My 2¢

    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

  5. #50
    Valued Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2007
    Posts
    949

    Re: The Bad Threads

    I remember seeing that, Mudraker. I was holding myself back from asking him if he understood how nuclear fusion worked, and if not, why the sun was still on fire.
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  6. #51
    Forum Guru mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,984

    Re: The Bad Threads

    From where i am it is 8:41 pm & dark so therefore the sun can't be on fire
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  7. #52
    Forum Guru
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2003
    Posts
    2,286

    Re: The Bad Threads

    + 10 logics to you, Mudraker.

    Dub yourself King of Logic and wear a paper crown around the office (out of a cracker is fine, but extra points for making it yourself).

  8. #53
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,131

    Re: The Bad Threads

    now want i want is to under each column date have a formula that magically looks at the date in 1. and works out how many months there are before this date to the beginning of the year stated at the top of the column and also how many from that date to the end of the year stated at the top of the column. next i need it to take the number of months before the date by 2. and then times the number of months after the date by 3. and add together

    i am happy if i can get this far as the next stage still hasn't been made clear to me as to what is required but its likely to be either that the total of above then has to be mulitplyed by 4. OR take the answer the answers to above before adding together i.e. months x 2. and months x 3. are then multiplyed by two different figures then added together (hope that makes sense)
    My eyes are bleeding ...
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  9. #54
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,212

    Re: The Bad Threads

    My brain tried to escape out my left ear half-way through reading that. Lucky for me I had my finger in there, otherwise I might be even more useless.

  10. #55
    Valued Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    233

    Re: The Bad Threads

    Quote Originally Posted by Member View Post
    Hi everyone,

    I want to create a form by pressing a button.I want to maka a maco to do that so can anyone tell me how to do that.
    I had to hold back on this one, how do you keep calm?
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!

  11. #56
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    MS 2007
    Posts
    4,972

    Re: The Bad Threads

    This one was fielded by NBVC. It makes perfect sense
    Quote Originally Posted by member
    I don't want a VBA solution - I was looking for something (non macro) that I would use in a macro, but also be using outside of macros.
    ChemistB
    My 2¢

    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

  12. #57
    Forum Moderator NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003, 2007, 2010
    Posts
    31,126

    Re: The Bad Threads

    Quote Originally Posted by ChemistB View Post
    This one was fielded by NBVC. It makes perfect sense
    LOL,,I was actually going to post that very one here.. it took me several reads .. but then I figured I'd guess the OP is looking for something like the List feature... Notice how long it took before I posted the answer to that..


    I guess I am a glutten for punishment as a recent one here was also fielded by yours truly too
    Last edited by NBVC; 06-04-2009 at 04:37 PM.
    Microsoft MVP - Excel

    Where there is a will there are many ways. Pick One!


    Please read the Forum Rules

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

    Preferred Charities: Lupus Canada and Sick Kids Foundation.
    Feel Free to Donate if you want to, for the assistance you received today.

  13. #58
    Valued Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    233

    Re: The Bad Threads

    Hi everybody,

    I am getting problem in sorting the records in Access 2007.The records in Microsoft Access 2007 database table can be sorted A to Z or Z to A for text, memo or hyperlink data types. Number, currency and autonumber data types can be sorted from smallest to largest or largest to smallest. The Date/Time data type can be sorted oldest to newest or newest to oldest while the Yes/No data type can be sorted selected to cleared or cleared to selected.

    Can anyone have some solution.

    Thanks in advance.
    Are any of you mind readers?
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the scales and adding to my reputation, Thanks!

  14. #59
    Forum Guru mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,984

    Re: The Bad Threads

    How about a thread that it is crossposted & has no discription of what is required - Need to access another forum to read what is required

    http://www.excelforum.com/excel-prog...-workbook.html
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  15. #60
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003 & 2007
    Posts
    3,661

    Smile Re: The Bad Threads

    ...and you, Mudraker, never lifted a finger to help.

    Shame on you, man.

    DominicB
    Now available : Ultimate Add-In 2007
    Integrates directly into the Office Excel Ribbon


    Download Ultimate Add-In v1.52 from www.dom-and-lis.co.uk
    90+ Utilities, 200+ Sub utilities last updated 25th April 2008
    Free!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. No Response Threads
    By Caligula in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 1
    Last Post: 03-19-2008, 02:05 PM
  2. Replies: 5
    Last Post: 08-28-2007, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0