Congratulations Bob on 10,000 posts (and never a "Thanks for the feedback" amongst them! )
Keep 'em coming.
In awe,
Malcolm
Congratulations Bob on 10,000 posts (and never a "Thanks for the feedback" amongst them! )
Keep 'em coming.
In awe,
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Bravo man
keep it up.
Thanks for helping us
Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
Practice this & save time of others in thinking for unsolved thread
Bob,
That's quite a milestone. Congratulations and many thanks for your consistent, timely, incisive, cleverly creative, and illuminating solutions. You set a very good high bar for me to strive towards.
Thanks!
Ron
Windermere, FL
10,000 - and never a cross word?, go on treat yourself to a few you've earned it!
Usually with a post count like that you could argue that its quantity not quality - well i'm not one to argue
Well done my old mate for sticking with it....lol
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Thanks Bob, your contributions have helped make this board a great place
Malcom>> I think he deserves a title for that *hint*
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Please also see: http://vbaexpress.com/forum/showthre...481#post145481
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Zack, that post was very well written, and I couldn't agree more.
Bob, I'm proud to be able to call you a friend, and am glad that you came here to share your experiences, views and expertise with all of us.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Wow Zack, when you create a dignity, you create a dignity. I hadn't considered you might add him to the peerage. It's like our own little VBAX realm now
Zack >>>
Bob >>>
Simon >>>
Aaron >>>
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Well done Bob, your contribution is highly regarded.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
For my part Bob I wish to issue a heartfelt thanks. I always read your responses and am better for it. Thanks for giving your time here, it is much appreciated. I too am in awe of your expertise and inspired by your generous nature.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
What a relief! I thought Bob was sponsoring a race. Running is not my cup of tea.
All kidding aside, your skills and contributions here are epic. The amount of code that you have helped write is simply staggering. The members at VBAX are certainly lucky to have someone as willing as you to assist us.
I've learned quite a lot from your posts and have the utmost respect for your contributions Bob (even if you continue to insist that I spell color wrong!)
Your slavish admirer,
Brandtrock
Thanks for all of the kind words guys. It is really an honour to be the first to 10,000, but it is also great that VBAX now has a a 10K poster, just up to you guys to get there as well and big up the site's kudos.
Oh, and Malcolm ... thanks for the feedback.
Last edited by Bob Phillips; 06-04-2008 at 09:54 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Very true. A considerable amount of what I know comes from you, Bob, and when I help others, often the only thing I do is distributing your knowledge. (Without permission )Originally Posted by Zack Barresse
I'm sure many others feel the same way.
You have a teacher's insctinct, feeding disciples just enough knowledge to help them get over some difficulty or other. This way you keep us inspired, and interested in doing our part of the solution. Also, this way you keep us feeling entitled to half of the credits
For me, it doesn't feel right to congratulate for the 10K+ postcount, because it's just a side-effect. The essence is that you are a helpful man with a generous nature, who can always be counted on. My deepest respect and thanks for all you have done here. And my wish for you is that you can do the same in the outer world.
Jimmy
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
Congrats, Bob. Well done! You set the bar high for everyone!
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Thankfully, it's so high that I can stll creep under it!Originally Posted by shades
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Originally Posted by xld
That didn't break the board software! I was sure it would!
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
No, but I have been in therapy since ...Originally Posted by Ken Puls
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
LOL! Is the therapist okay? <evil grin>
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
And I bet your therapist will shortly need their own therapy...Originally Posted by xld
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables