at this rate we need a few more characters in the title field ... nice work Ken
the next cell master
at this rate we need a few more characters in the title field ... nice work Ken
the next cell master
Congratulations Ken.
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'
Way to go Ken...
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Congratulations Ken! A very deserving and fitting title! I look forward very much to your write up!!
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
Man, what a rogues gallery over there. I have seen better looking line ups on America's most wanted.
Congrats guys!
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
good to finally see your mug up on Colo's page too Zack, I enjoyed the write-up
Congrats, Ken!
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
Are you calling me wordy, Dave?Originally Posted by brettdj
Thanks, guys. It feels a little weird to be on the same web page with many on that list, and there are some people whose names I think should have been there loooong before mine.
At any rate, it's Zack's turn to be featured now. Eyes on him.
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!
I KNEW I recognized Zack from somewhere!Man, what a rogues gallery over there. I have seen better looking line ups on America's most wanted.
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!
Well done Ken
Congrats Ken
K :-)
I KNEW I recognized Zack from somewhere!(Please don't tell anybody..)
Dave, thanks. Nice to hear some feedback on it.
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
Hi Guys,
Great news Ken! Much deserved if I may add!
It was nice reading your cell master post Zack!
_________
Groetjes,
Joost Verdaasdonk
M.O.S. Master
Mark your thread solved, when it has been, by hitting the Thread Tools dropdown at the top of the thread.
(I don't answer questions asked through E-mail or PM's)
Just finished reading yours, Ken.
Did read Zack's some time ago. Kudo's gentlemen.
Ah yes, early 2003, I remember it well.
Regards,
Nate Oliver
Sorry for the late reply on this.Ah yes, early 2003, I remember it well.
I remember it well too, Nate. I actually still use some of the macros that you helped me build back then.
I actually wanted to "officially" thank four people who got me started in to this stuff. There's been many more, as I've learned from everyone who helped me, and whom I've helped as well, but these four were pivotal parts in my route to here. They are (roughly in order that I met them...)
Nate Oliver. Nate helped me with Excel issues at UtterAccess.com, and was instrumental in exposing what code could do for me.
Smitty (Pennysaver). I met Smitty at MrExcel, after actually following one of Nate's posts there. It was Smitty's friendliness, helpfulness and ultimately advice that led me to purchase my copy of J-Walk's Power Programming with VBA book. Without that book, I highly doubt that I would be here now.
Zack Baresse. While I'd seen Zack in a post or two at MrExcel, I really met him here after following a link in Smitty's signature about VBA certification. Through a somewhat controversial post, Zack somehow decided that I should become a moderator here.
Anne Troy. I first encountered Anne back at UtterAccess, but didn't really get to know her until I came to VBAX. Since that time, Anne has become one of my greatest friends, and has given me some great opportunites, including my first few consulting jobs.
Again, these are the four people who went above and beyond for me, believed in me, and truly made me want to do more and learn more with VBA, Excel and Office in general. It's because of them that I play my little part in forums and on the web these days.
Now there are many, many more who have contributed to my knowledge. I have a great many friends from a variety of forums who have helped me expand my knowledge. Some are Cell Masters, some are MS MVP's, some are website owners, some are prolific forum posters, and some have simply asked a question or two that I have been able to help out with. The important thing is all have contributed.
Okay, that's enough about me. I've been thinking about this for a month, but did want to place the credit back where it is due on this.
Cheers,
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!
He's lying.Anne has become one of my greatest friends...
~Anne Troy
Ha! I remember that post! LOL!Through a somewhat controversial post, Zack somehow decided that I should become a moderator here.
Ken, I believe I can speak for the majority here when I say you're an inspiration to us all. Thank you for your unyielding contribution to this community.
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
Ugh. I knew somebody was gonna make me barf.
(Seriously, tho, I love hell outta all youze guize and goils.)
~Anne Troy
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!
Yeah. As if that wasn't bad enough, I don't see the barfing smilie anymore, either.
~Anne Troy
Posting Permissions
Reply With Quote
