Excel Experts-Exchange Regulars, take 4

If I tried to make a "nice Excel Mothersday toolkit" my wife would probably
initiate divorce proceedings :)

Patrick:

That's pretty good...  I imagine you're not alone on that front.

Jaes

Guys:

Okay, so I have a link to show me the unanswered questions in the Excel TA.  Does anyone have a link to view the Answered Questions like we used to have.  A question was just answered and I wanted to know the answer, but I can't find it.

Thanks,

Jaes

Jaes,
When I see a question where the answer might be interesting, I click the link at the bottom of the question box to "Monitor Question".

You can also construct a search query using the "Advanced Search" capability for questions in Excel Zone that were answered in the last 1, 3 7, etc days. There were 241 answered in the past 7 days: http://search.experts-exchange.com/advancedSearch.jsp?cid=325

I can see the grade assigned to the question in the results of this Search, something that is normally missing. I can also see which zones the question was asked in, something I could only do using my Page Editor powers.
Brad

Brad,

Given that the advanced search is pretty much a query, do you know of a way to sort the results?

For example, if I use a query of "taid:(604) typeid:(30)", and display 100, it seems to show the results from earliest to highest, or something like that. I'd like to get the newest questions at the top.

Cheers,

Wayne

Brad Yundt, a.k.a. Steve Austin, the Six Million Point Man! Lemme hear ya say "Woohoo"! :)
Congratulations, Brad!
Rory

Congratulations, once again, to Brad:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22577708.html

Brad, Kevin, & Company:

I'm not sure of the EE Site rules behind this.  I understand posting a link to an answer in a question, but check this out.

http:/Q_22576808.html?#a19106053

Is there anything that says that Experts shouldn't refer those that ask questions to other Excel Forums?

Just curious...  especially since he got some of my points and didn't even answer the question.

Jaes

Jaes,
The rules are quite clear: you cannot suggest that an Asker post their questions on another forum. It is quite acceptable, however, to post a link to a specific place within that other forum where the Asker's question is answered. I'll get a Mod to pay attention to it (it's not the first violation).
Brad

Brad:

Did any of the Mods say anything about dr_shivan's (http:/M_2599043.html) post?

Thanks for the link to the advanced search.

http://search.experts-exchange.com/advancedSearch.jsp?cid=325

Is there a way to return the results a list rather than brief summary form?

Thanks!

Jaes

Jaes,
I did contact a Mod, and he promised to follow up on the issue--but I don't see the signs of it yet. It may be that the issue is getting kicked higher up (and the Admins are out of pocket until Sunday).

Brad

All FYI:
[ http://labnol.blogspot.com/2007/05/upload-and-save-microsoft-office.html ]

May 18, 2007
Upload and Save Microsoft Office Documents Online in One Click
posted by Amit Agarwal on 5/18/2007 11:18:00 AM
===    
Box.net, the online file storage service that offers 1GB of free storage space, has developed some excellent add-ons that could make this service a darling for Microsoft Office users.

Box.net offers a virtual file explorer for your uploaded documents, pictures and videos. You can put this file explorer anywhere in your website and visitors can easily navigate through your files, download them offline or they can subscribe to your files in their newsreader.

Today, Box.net unveiled another useful service called "Office on Demand" - this is an add-on for your Microsoft Office programs that will let you save files directly from Word, Excel or Powerpoint directly to your online Box.net account. No need to launch your web browser.

Other than the convenience factor, Box.net is tightly integrated with Zoho Docs and Zoho sheet. Even if your computer has no Office license, you can still edit the .DOC or .XLS files from Box.net directly in Zoho Office and save the edited files back to Box.net.
===

Download link provided:
[ http://www.box.net/shared/m0jjh7n610 ]


BFN,

fp.

Does anyone have access to a copy of Excel 2000 on which they can test opening the csv file in this question: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22584347.html
?

Never mind - the asker has worked out the issue!

Anyone have any thoughts on this one: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22602384.html
I'm pretty much out of ideas now!
Rory

Thanks, Matt, that one was beginning to bug me! :)

Not a problem :) Lets all hope none of us ever have to work in that kind of environment!

I don't know if it has ever been mentioned, but Kevin was granted Page Editor powers a few weeks back. He started with a rant to Netminder about the new user interface, and after many subsequent discussions decided to join me as co-Page Editor for the Excel TA. That's a good move for all parties.

I don't anticipate any changes in policy within the Excel TA as a result of this change. Having an extra set of eyes able to take care of problems is a good thing, especially if one of us happens to be taking a day off.

"...especially if one of us happens to be taking a day off."

Oh Brad, you are soooo funny! :)

Anyone ever tried the translate functionality which is nowadays on EE?
I just played along a bit and I have to say that it is awfull.
It mixes up standard Excel functions. parts of them stay in English and parts of the functions are translated.

Perhaps somehow this functionality comes handy in some way when questions are written down in unexplainable. Perhaps translation give another point of view on the question:)

I played a little bit with it too, and noticed the same things (also the "Date" header of a post gets blended with the username--I'm sure its still a work in progress).  
If EE creates some kind of code tag (or just a 'do not touch' tag), the translator can just skip that portion. Until then, not a greatly useful feature..
Is it on the "Post a question" page too? would be interesting to ask a question in another language then see how it translates into english, would probably make for some fun threads :)

As far I saw it is Googles translation function incorporated.
when moving over the translated sentence you see a google pop-up.

Perhaps they should embed some spell check instead. And to draw it even further, an excel function checker :)

"...would be interesting to ask a question in another language then see how it translates into english..."

I wonder if there is a US Language<->English Language conversion? ;)

An old friend has returned:

http://www.experts-exchange.com/Q_22634052.html
http://www.experts-exchange.com/Q_22635574.html

Hi guys,
Good to see that you're all still here.
I can see the top-10 starting above 1 Million points.... Congrats to all of you guys!!!! Several of you, by breaking the 6-million level, are even making Steve Austin jealous.

Well, I don't think I am back for the old 7x24 schedule, but i'll see you around.

Seb

Just wanted to pop in and say hello. It's been a while since I was here...

/Ture

"...are even making Steve Austin jealous."

If only those points could be converted to prizes (or even dollars), we could all have retired a long time ago.

Good to see you both back guys :)

BFN,

fp.

Welcome back guys.
I hope everything is going just fine.

Jeroen

Anyone out there with outlook 2003 mind testing something for me please (for http:/Q_22635190.html )? Sound is necessary
Download http://www.hastalavidas.com/OneStopPCHelp-OutlookSoundNotification.zip
That zip contains 4 files:
 "notify.wav" - extract to C:\ (or change in .bas file the location)
 "ThisOutlookSessionCode.txt" - copy/paste code into ThisOutlookSession object in outlook vba
 "vSoundMdl.bas" and "vSoundCls.cls" - import into outlook VBA project

To test:
 -Open new mail message, address it to yourself. subject/body are unimportant, don't send just yet
 -Change focus to something other than outlook, then re-focus on new message. click send
 -After a couple seconds, the .wav file should repeat until outlook application gets focus

Much thanks!!
Matt

Hello Matt,
The sound didn't ring.
Sorry to say.
Did what you wrote down. Im sure it tried to get the sound file since I forgot it initially and debugged with the message file not found, when continue it played the sound. Onlye not when lossing focus etc.
Hope this helps.
Jeroen

Hmmm.. I really thought it would have no difference in 2003 (vs 2000). I even created a new .otm file for this, thinking maybe a stray module or something had an API call I forgot to declare in the attached files, and it still works fine for me.
I'll have to install 2003 at home (I got office2k3 on cd with my laptop but prefer 2000) to figure out why it isn't working..

FYI - I should have included this earlier, but the sound would only play when a new message is received and outlook doesnt have focus. once outlook gets focus the sound is stopped (until the same conditions are met again)

Thanks though!
Matt

July 1 was a very good day for the Excel TA as Kevin, Rory and Matt were each awarded the Microsoft MVP for Excel.

I assume that Shane Devenshire and Ture repeated their awards as well.

Congratulations to each, for a well-merited recognition of excellence and perseverance!


Brad

Don't be so modest, Brad, you forgot to mention yourself in that list!
Congratulations to all!

Congratulations, Kevin, Rory, Matt and Brad!
I think it is more then wel deserve looking what you are doing for the excel community.
No the worse task is maintaining the award :)

Jeroen

Congratulations to all of you!

Well deserved and long due!

Xanius

Congratulations guys and thank you again to the kind (if misguided) souls who nominated me! :)

Careful there bud, you make most of us look like hacks...so if you feel you are not worthy, then I guess I'm somewhere below that.

Congratulations to each of you.

There seems to be a "round in" error, though :)

(But given that an MVP is paid as much as an Experts-Exchange contributor we'll let you off with a warning this time)

BFN,

fp.

I never said there was a connection between your being a misguided soul and my nomination! :P

congrats to all of you, well deserved as always :)

Congrats guys! Well done and very well deserved!

Unfortunately, I'm not an MVP awardee at the moment - I've been too low on activitiy here lately. But I hope to get back in someday, when I deserve it again...

But right now I'm not of much use here. I'm on two weeks vacation, trying to play golf and enjoy the company of my family. But after that, I'll dive back into the Excel TA - one of my favourite places on the web.

Best regards / Ture

Does anyone knows if the rules to become an expert are changed. In the early days you could sign on for free, get a few free points to ask questions and if you liked it you could or become an expert earning points and a free membership for 3000 pnts a month.
Today I told an colleague about this site and he tried to sign on. He only could continue by paying in advance. Is the old feature removed or did I missed something?

Jeroen

The rules are still the same (10,000 points to qualify for free, then maintain 3,000 a month with one grace month each time you don't get 3,000), though I think the Free Signup link isn't extremely well advertised (so they get more paying people)
http://www.experts-exchange.com/registerFree.jsp

Thanks Matt,
I knew that the rules where changed, only becoming member for free was very hard to find. Still hiding that link will cause more and less in lesser new users. Or they are very eager to pay.

Have a nice weekend
Jeroen

And another: https://mvp.support.microsoft.com/profile=7078E99C-4E11-4458-9083-8AD69B75C943

Kevin's link is for matthewspatrick receiving the MVP award, if you aren't able to log into the web site.

Congratulations Patrick!

I was just logging on to mention that!
Congratulations, Patrick!

That link works if you are not logged in. In other words, anyone can view it. You may just think you have to sign in because you already have some cookie stuff going on.

Kevin

I confirmed the link by sending it to my wife (and she is definitely not an MVP...in fact, I'm afraid to tell her I am because it will start the conversation about how much time blah, blah, blah ;-) and she was able to view Patrick's details without any login prompt.

I viewing "Mr.  Patrick  Matthews" MVP profile without any issue too.

Congratulations to you all (once again).

:)

BFN,

fp.

"I viewing"... sometimes English is my secondary language... with gibberish being my first! :)

Does anyone know if Jim Everist was also awarded for the first time this year? He is on the MVP site, his profile matches his EE profile, and it was updated this month:

https://mvp.support.microsoft.com/profile=9BF1041F-D078-41EB-A15E-1F4DC232D576

Way to go Jim!

Wow, I get busy for a month and come back to find I'm in the company of serious professionals now.  Perhaps I should go back and hide under my laptop for a while longer.  Seriously though, that's so incredibly awesome guys!  I'm jealous, but all of you deserve it!

So yesterday I was working on finance forecast and somehow accidentally found the shortcut to reverse the column headers to show Z-A with the row headers on the right instead of the left.  I have no idea how to do it.  I searched the internet and figured out how to make it go back through the Options menu, but cannot find the shortcut documented anywhere.  Have any of you heard of said shortcut?

Miss you guys!

I can't find a keyboard shortcut for that feature. I suspect your xlb file is buggered. In customization mode, put the command in a menu and see if a shortcut is listed. The command is listed near the bottom of the Format menu.

ALT + tow will toggle the "Right to left" feature on and off.

That's not a keyboard shortcut per se though. Those are menu keys - each pressed separately. And you have to add an ENTER to complete the operation.

Jaes: any possibility you would have tried to entered the text "tow" anywhere?

It's crazy I know and it is possible I pressed a series of keys, but I never saw the options window open like it does when you press Alt+E+S+V+Enter.  I still think there is a shortcut.  The only good thing I can think to use it for is as a prank for someone's device, but I don't know how else I could have done it.  I was working on a spreadsheet and all of the sudden it was reversed.

It's official, Jim received the MVP award this year, mostly for his work here on Experts-Exchange!

EE MVP Experts:

That is so very cool.  I have had a desire to be Excel MVP ever since I found Chip Pearson's web site back in 1999.  I had a chat with him at one point since he lives in the Kansas City area.  I never knew that I would have any avenue to achieve this dream, but you guys have given me hope.  Since I don't believe I will be hired for the new job that I recently applied I'm going to try and focus a little time each day to EE in hopes of someday making Genius and now perhaps even an Excel MVP.  :)  To be honest though, even if I never make either I'm just happy to have made the acquaintance of all of you here.  You have all taught me things I never could have learned on my own.

Here's a perfect example.  I have two charts on one spreadsheet one on top of another.  I wanted to reverse the data in the lower one that gives a data table showing the % increase or decrease from the previous quarter.  I used to manually add this formula trying to figure out which column and row to use for each one.  It was a pain.  Then today I remembered the INDEX and OFFSET functions and wrote this simple little gem.

=IF(OFFSET($A$1,MATCH($A12,$A$2:$A$8,0),MATCH(B$11,$B$1:$O$1,0))=0,0,OFFSET($A$1,MATCH($A12,$A$2:$A$8,0),MATCH(C$11,$B$1:$O$1,0))/OFFSET($A$1,MATCH($A12,$A$2:$A$8,0),MATCH(B$11,$B$1:$O$1,0))-1)

Now I have one formula that I can copy and paste and I'm done for the quarter for this chart.  If not for you guys I would never have even had any idea that something like this existed in Excel.  You guys are the best and always will be!

Kindest Regards,

Jaes

:-)

Nice, Jaes.

I will say that I was pretty surprised by it and a little flattered.  But as I've said before, the Experts in this TA have always been MVPs in my book.  It's kind of nice that the folks in Redmond finally noticed what a great job that our experts like Brad, Matt, Kevin, Rory and Patrick are doing helping their customers to utilize Excel to its fullest extent and increasing overall customer satisfaction.  There are others just as commendable including Patrick (ab), Jeroen, Nigel, Dave, Geoff, Wayne, Jaes, Seb and Ture among others.

Thanks to all,
      
Jim

Fellow Experts,

I tried on this one, but I cannot make sense of it.  Any of you feel up to the challenge?

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22699358.html

Patrick

wow, great news

congratulations guys on the MVP awards

Cheers

Dave

Seems that our well beloved MS Excel is used more often for SPAM purposes. Will this end into prohibting excel files to be send by mail in the future?
Or will there be a growth of digital signatures using in excel files?

http://www.eweek.com/article2/0,1759,2162170,00.asp

Haven't seen an Excel attachment yet but have seen plenty of PDFs lately. Also seeing the bogus greeting card from a friend/mate/family member/partner/blah blah blah.

One of these days our stupid politicians will realize they can't regulate this crap and will finally put into place one of the numerous authentication schemes that have been proposed - years ago - and we will all be saved.

I did retrieved the excel 2ce still don't know what is in them :)
The bogus greeting cards didn't work for me as well as Im aware I don't have friends anymore since I strat spending my time on EE.

Still those authentication schemes will also be hacked. I still cannot believe that people are so ignorant and belive that making easy money or bying high quality stuff for free or low prices. perhaps we need per person at least 2 mail adresses, 1 for personal mail and one for commercial mail. personal mail can only be retrieved when someone is in your retrievers list, people have to manually add them and one commercial mail where all non-personal mail goes. Thinking about this, I already have a simular thing like this: all commercial mail is going into the trashcan folder :)

I showed a user how to trap Application events, but he needs help implementing it
in a COM add-in:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22705800.html

Patrick

I'm sure we all know somebody like this:

[ http://www.dilbert.com/comics/dilbert/archive/dilbert-20070808.html ]
or
[ http://www.dilbert.com/comics/dilbert/archive/images/dilbert2003055270808.gif ]

:)

BFN,

fp.

Just moving a bit on EE I came up to this question. I have to say I was a bit dazzled. Perhaps a classic case of a pitfall on EE. When you think you are giving some direction towards the sollution, before you know you are in an assignment to write a full paper of risks etc.

I was intending to response to this Q though I don't have the time to do a complete investigation programm. Now Im currious how angelIII will react :) Will angelIII be restricter by the technology of EE since it wont be possible to give a 2 paper response at once?

http:/Q_22736848.html

Or is this someone who wants to use EE as a homework portal?
I never saw an question with so precise requirements " i want a report of 2 pages atleast."

:)
Jeroen

Has anyone seen Matt? -> http:Q_22766115.html

FYI:

30/10/2006: E-mail from NetMinder suggesting I may get a T-Shirt for my [then] recent accomplishments at E-E.
20/08/2007 [i.e. today]: T-shirt arrived bearing the address label text: "fanpages Medium Genius".

One wonders if there are sub-levels of "Large Genius" & "Small Genius" in this rank now.

:)

I was a large genius. though when my wife said it, it sounded suspiciously like 'jackass'.

When I hit Genius in Access a couple of weeks ago, I said to my wife "goody, I earned another
t-shirt."  She gave me that "you poor, poor man" look and asked me, "so, will this one say
genius, or will it say freakazoid?"

Some people just don't get it :)

...so neither of you have dared to wear your shirts whilst out with your other halves then?

Perhaps E-E could send you both a pair of trousers too? ;)

[ http://www.phrases.org.uk/meanings/403100.html ]

OK. I have to admit, I wear the T-shirt.
It is the only moment someone else shout at me calling me Genius. I believe my wife is allowing me since she always in for a good laugh

My children adore me since I explained a huge world-wide institution thinks I'm a genius and awarded me en perhaps in the nearby future it will make me rich. It also might have to do with the translation from English to Dutch :)
My sun understood the word rich and start asking me when Im going to buy the long-ago-promised-knight-castle. I think I have to build it in Excel and convince him that Excel is a very good application.

Anyone care to chip in here: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_22819351.html

Rory

Yay Jim!

http:/Q_22820867.html

For those who haven't heard, occasional Excel TA participant angelIII http:/M_302115.html will be dialing back his site participation due to some bad news on the home front--his wife has been arrested and charged with murder. Between wife, child and job, he has a full plate. My sympathies are with him.

Whoa... I hadn't checked his profile so I didn't see that.

Guy, if you're subscribed to this and (for whatever reason) checking this, hope everything works out! I hope for the best

SQL Server question, but I know some of the Experts here are pretty handy with SQL:

http://www.experts-exchange.com/Database/Miscellaneous/Q_22828650.html

This question is mine, so I'd really appreciate any help :)

Patrick

Happy 37th Jaes!

If any of the London based guys see this I'm in town for the next few days, staying near Green Park in the city. Let me know if you are free for a beer.

Cheers

Dave

To whom who wants to know.
There seems a minor bug in Excel 2007.
When a calculation should come to the number: 65535 then it displays: 100,000
like: 850*77.1

for some other examples:
http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/2bcad1a1a4861879/2f8806d5400dfe22?hl=en#2f8806d5400dfe22

Will this also infect the loop through Rows. Will it skip the rows between 65535 and 100,000

Anyone here who works for 850 hours a year for an hour rate of $77.1?

Jeroen

More info on the Excel 2007 bug here: http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx

Rory

Anyone have any idea what's going on here?

http:/Q_22853211.html

Here I came to post about the bug and my fellow experts already know...

I never received my T-shirt.  :(  Anyone know how I can get mine?

Did you at least have a happy birthday?

When was it, Jaes? I won a master shirt for outlook 06/15/2007 (per the expert shirts page) and just received it maybe 2 weeks ago

I had a pretty good birthday.  For anyone that cares (i.e. Kevin) I made it successfully to 37.

Thank you Brad!  I guess this means I need to get to Genius so I can get a shirt.

Work has been crazy the past couple months, but I need 2k points so I don't lose my expert status, so I'll be trying to answer a few questions over the next few days at least...

Miss you guys!

Well I received an E-mail near the end of last year from one of the Admins who asked for my mailing address.  Brad was involved in part of the conversation if I recall.  I gave him all the info, but no shirt...  What's the expert shirts page?  Things have changed quite a bit since I was here last.

Click the link to Edit your profile, verify your password, click the "For Experts" button, then go to the Expert Shirts. There should be a link there to send it
I also got the email from NM last fall, but didn't get the actual shirt until this expert shirts page was added

Happy belated b-day!

Thanks man!  I do have a shirt to Redeem...  I don't care if you guys wear yours or not.  I'm going to wear mine at the Bookstore with pride.  Now I need to get back to the questions to snag a couple from Rory before the day is out...  Cheers!

Happy Birthday, Jaes - you're the same age as me (for a few months at least!)
Rory

Thanks Rory.  For those of you that want to put it on your calendars.  09/22/1970.  Share your birthday here and I'll add it to my calendar to put well wishes on our private EE question for you.  ;)

Of course, the person involved has to notice the birthday greetings. I was perhaps a little too obscure here: http:/Q_22567885.html#a19942874

Brad!  You are so awesome!  Thanks man...  I do need to pay more attention...  You probably sent an E-mail to me, too...  Perhaps I should stop working so much and catch up on my EE...  Things have changed around here...  I noticed that I'm close to getting knocked off the Top Expert list so I'd better do something about that.

You may notice new expert mikefos posting comments in Excel threads. This would be Mike Fosmire, whose day job is identifying MVP candidates for North America in Excel and several other Microsoft technologies. He joined EE in January, and recently expressed an interest in seeing what the answering side of EE was all about, so Kevin invited him to participate. Mike was recognized as an Excel expert by previous employers, and reads thousands of posts as part of his current job--so I wouldn't be the least surprised if he shows us a few new tricks.

I hope you will join me in welcoming Mike when he posts in one of our Excel threads.

Brad

Does that mean I have to stop getting things wrong, or lose my MVP award? :)

Jaes,

Fun story! I did the Blazin' Challenge a couple years ago too, though I didn't get a t-shirt. I did, however, get my picture on the wall (for a few months) and the wings for free :) Congratulations, that is not an easy feat. At least you realized your mouth wasn't going to cool down any time soon and your body was going to hate you anyways, so there was no reason to stop once you started. They don't even give you free wings anymore at our BWW for doing it, otherwise I'd love to try it again.

And a big welcome to Fozzie!
Matt

Jaes,
I'm surprised nobody suggested a SUMIF in the thread you referenced. It has wildcard capabilities and can even handle entire columns when asked nicely.
=SUMIF(Sales!$D$2:$D$20000,A16 & "*",Sales!$E$2:$E$20000)

Brad

Brad:

The crazy thing is that I tried to get SUMIF to work before Kevin even posted and couldn't get it to give me the right answer.  Then I tried to get LEFT to work after Kevin posted and couldn't get it to work until Patrick figured it out.

Jaes

Just to keep you all aware, I was informed a little over 2 weeks ago that my group at work will be losing our jobs at the end of the year (12/31). This is due to some regulatory and corporate reasons that few would likely want to hear (will explain if you want). I'm not heartbroken over this, as I am taking it as an opportunity to get into a position where my skills might actually be used and I'm getting a small but still decent severance (7 1/2 years here). I think I'm going to try my hand at first the contracting market and then hopefully consulting (and doing lots of research on both).
I doubt this will really effect my forum participation, as I love helping out, and it may finally put an end to some of my privacy concerns since I would no longer really have to keep an eye out for corporate big brother coming down on me.
Anyways, just keeping you all in the loop
Matt

Matt:

Sorry to hear about your job.  I was just reading an article last night that talked about how many people don't realize that they could make as much as twice what they currently make by looking at different markets where they can fully utilize their skills and be compensated well for it.  Sometimes it takes a life changing event to open one's eyes to even better opportunities.  I wish you the best.  Keep in touch...

Jaes

Matt,
Good luck with that - it may turn out to be just the kick you need! :)

If anyone can help with this one, I could use a hand: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q__22870176.html
Especially as I'm off to the beach for a fortnight...

Rory

Matt,
Good luck with the next steps in your future. Someone told me once that every point/moment were decisions will be made in life at a certain time you will see the benefits of it.

For the time being you might spend your time at this Q: http:/Q__22875811.html

Seems that someone pasted a complete functional design or is well spoken to explain his/her needs.

Jeroen

Problem with the VBE in xl2007 - > http:/Q_22891169.html

problem with me -> http:/Q_22907070.html

Though more people are attending the Excel zone which result in lesser congrat-Q's for Master, Guru, Wizard and Sage. Still to become a Genius is quite a job.
Recently Wayne made it to this level. For celebration I created the following Q's.
http:/Q_22920314.html

For anyone who is handy with manipulating popup menus and workbook events:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_22931490.html

Cool... code snippets

Debug.print "It is about time!"
Goto 1

                                              

1:
2:

Was there ever a congrats thread for Geoff?

Congratulations Jim,
"Valedictorian (Expert with the best grades): jeverist "
http://www.experts-exchange.com/twoMillionSolutions.jsp

Jeroen,

Wow, I didn't see that!  Amazing, thanks!  I wonder what formula they used to come up with that?

Jim

Indeed amazing :), no kidding, still have to look up what it exactly means.
I think it would be something like:
=IF(username = "jeverist","Valedictorian (Expert with the best grades): jeverist","")

Perhaps time to close this Q and start a new chapter?

Jeroen