Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: What code/formula/solution makes you most proud?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    California
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    May 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ).

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •