Consulting

Page 4 of 4 FirstFirst ... 2 3 4
Results 61 to 73 of 73

Thread: Challenge: Triangle Area Select tool

  1. #61
    VBAX Expert
    Joined
    Dec 2007
    Posts
    522
    Location
    Quote Originally Posted by mdmackillop
    Check that is is a valid range before passing it to the sub routine. Consider
    [vba]
    MsgBox TypeName(Selection)
    [/vba] You can use this result to determine how the code proceeds.
    Md, that is actually what i did to solve the problem, except i did it in the immediate window.

    I just wanted to get your opinion on whether I was doing my testing correctly !

  2. #62
    VBAX Expert
    Joined
    Dec 2007
    Posts
    522
    Location
    Quote Originally Posted by mdmackillop
    BTW, If anyone does not understand the concept of "Project Creep", I shall point them to this thread!!!
    md, I take your comment in jest and good spirit .

    I felt though, that I've tried to contribute where possible to the discussion, but the key brilliance of coding has been p45cal Bob and yourself, which I very much appreciate.

    If I have asked many related questions, the purpose is two-fold, namely to learn new techniques and also develop a tool that would be useful in my day-to-day work.

    I can;t tell you how many times in my line of work we have to look at data this way and how useful this tool already is - if that offers any consolation.

    regards

  3. #63
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by xluser2007
    md, I take your comment in jest and good spirit .

    I felt though, that I've tried to contribute where possible to the discussion, but the key brilliance of coding has been p45cal Bob and yourself, which I very much appreciate.

    If I have asked many related questions, the purpose is two-fold, namely to learn new techniques and also develop a tool that would be useful in my day-to-day work.
    I think that I have explained in my response that it is questions like yours that draw me to VBAX, so no apologies, keep 'em flowing!

    Quote Originally Posted by xluser2007
    I can;t tell you how many times in my line of work we have to look at data this way and how useful this tool already is - if that offers any consolation.

    regards
    :
    Well, money is a better consolation , but failing that, we'll just have to spank your cricket team
    ____________________________________________
    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

  4. #64
    VBAX Expert
    Joined
    Dec 2007
    Posts
    522
    Location
    Quote Originally Posted by xld
    I think that I have explained in my response that it is questions like yours that draw me to VBAX, so no apologies, keep 'em flowing!


    :
    Well, money is a better consolation , but failing that, we'll just have to spank your cricket team
    I thank you for sharing the first response Bob. It's people like you, md, p45cal, GTO, mikerickson et al that keep me coming back here!

    As for the second response...I have a a friendly pool with an office pom that we would have this series 2-1. Still can't discount the possibility in terms of matches to be played but in terms of the current English form we'll have to see ...

  5. #65
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by xluser2007
    Still can't discount the possibility in terms of matches to be played but in terms of the current English form we'll have to see ...
    Don't forget our weather, we can always call on that, and the long term forecast is no more sun this summer.
    ____________________________________________
    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

  6. #66
    VBAX Expert
    Joined
    Dec 2007
    Posts
    522
    Location
    Quote Originally Posted by xld
    Don't forget our weather, we can always call on that, and the long term forecast is no more sun this summer.
    How could i forget your greatest weapon (just kidding).

    You are right though, if there's no rain then i have some shot at winning my friendly bet.

    Also, could you please tell Freddy to take a day off...

  7. #67
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by xluser2007
    Also, could you please tell Freddy to take a day off...
    I think that will happen, his body is crippled.
    ____________________________________________
    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

  8. #68
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Quote Originally Posted by xld
    we'll just have to spank your cricket team

    Gees I must have missed something...... which team was bowled out for 102?
    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

  9. #69
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Poms 2 Convicts 1 ................
    ____________________________________________
    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

  10. #70
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Do you know how much pain I'm in.......?
    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

  11. #71
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Do you know the joy here ....
    ____________________________________________
    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

  12. #72
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    I suppose you'll be reminding me on the odd occasion for the next 18 months.
    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

  13. #73
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    18 months! We're still hearing about the World Cup win in 1966.
    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'

Posting Permissions

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