What code/formula/solution makes you most proud?

artslave · May 10th, 2002, 04:17 PM

We've all slaved over problems and eventually come up with a fun / efficient / clever solution that makes us really happy... unfortunately it's hard to share that elation with non-Exceller's at work -- even less so with non-computer-literate spouses and partners at home.

So I'd like to know about your personal little triumphs -- first for pure curiosity, second so I can congratulate you on your ingenuity, and thirdly, cos I always learn something when smart people show off!!

It doesn't matter what your experience level is either -- you don't have to be a guru to have come up with something useful.

So what is YOUR favorite solution -- a combination of keyboard shortcuts, a VBA macro, a formula (or combination of formulas), a method of charting, a custom toolbar button? Does your boss still kiss your feet for turning a three-hour process into a ninety-second macro? Does your accounting department think you walk on water? Share with an audience that will appreciate it....

Cheers!
Catherine

jkpd2000 · May 10th, 2002, 04:55 PM

2 days ago, i don't know the power of excel. after joining this board i came to know the real power. Now i am trying to automate a process with the help of this board which will save my 4 hrs every day. The automation process is still in progress, but i am over exited and posting this.

thanks for all those helped me.

Mudface · May 10th, 2002, 04:59 PM

Probably some code I wrote for our QC dept which took all the template workbooks I'd created for them and copied/ renamed them into a freshly created (if necessary) folder for the next quarter. The reasons were probably because it was a right pain to do manually, it used the FileSystemObject (which I'd not really used before) along with procedures and functions with multiple arguements and the code itself was considered to be a QA document and got incorporated into the QC procedures (which wowed several directors

).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 04:17 PM	#1
artslave New Member Join Date: Apr 2002 Location: California Posts: 26	We've all slaved over problems and eventually come up with a fun / efficient / clever solution that makes us really happy... unfortunately it's hard to share that elation with non-Exceller's at work -- even less so with non-computer-literate spouses and partners at home. So I'd like to know about your personal little triumphs -- first for pure curiosity, second so I can congratulate you on your ingenuity, and thirdly, cos I always learn something when smart people show off!! It doesn't matter what your experience level is either -- you don't have to be a guru to have come up with something useful. So what is YOUR favorite solution -- a combination of keyboard shortcuts, a VBA macro, a formula (or combination of formulas), a method of charting, a custom toolbar button? Does your boss still kiss your feet for turning a three-hour process into a ninety-second macro? Does your accounting department think you walk on water? Share with an audience that will appreciate it.... Cheers! Catherine

May 10th, 2002, 04:55 PM	#2
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	2 days ago, i don't know the power of excel. after joining this board i came to know the real power. Now i am trying to automate a process with the help of this board which will save my 4 hrs every day. The automation process is still in progress, but i am over exited and posting this. thanks for all those helped me.

May 10th, 2002, 04:59 PM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Probably some code I wrote for our QC dept which took all the template workbooks I'd created for them and copied/ renamed them into a freshly created (if necessary) folder for the next quarter. The reasons were probably because it was a right pain to do manually, it used the FileSystemObject (which I'd not really used before) along with procedures and functions with multiple arguements and the code itself was considered to be a QA document and got incorporated into the QC procedures (which wowed several directors ).