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
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!'![]()
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 assistedor failed to assist you
I welcome your Feedback.
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)
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)
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 assistedor failed to assist you
I welcome your Feedback.
+ 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).
My eyes are bleeding ...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)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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.
This one was fielded by NBVC. It makes perfect senseOriginally Posted by member
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)
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.
Are any of you mind readers?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.
"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!
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 assistedor failed to assist you
I welcome your Feedback.
...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!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks