Consulting

Results 1 to 16 of 16

Thread: Another noobie

  1. #1

    Another noobie

    I thought I'd introduce myself and be as vague about it as possible. I'm Dave and I'm a constant student when it comes to VBA. I have found it to be totally addicting and having code to make something happen is really good enought....I have to understand why it works. Hopefully I'll be well received here. I've read through some posts and found some conversations pretty interesting...
    What happens if you get scared half to death twice?

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Well Dave, welcome to VBAX. I'm confident that you'll meet some very clever people as you get around the forums.
    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

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Pretty interesting? I have been here 5 and a bit years, and I find at least one a day more than interesting.

    It's the best VBA site for Excel, bar none.
    ____________________________________________
    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. #4
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    That be one of the good guys Dave.... unlike me of course.
    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

  5. #5
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Quote Originally Posted by xld
    Pretty interesting? I have been here 5 and a bit years, and I find at least one a day more than interesting.

    It's the best VBA site for Excel, bar none.
    Dave - beware of this one!, discussions can get more than interesting but whatever you do when having discussion with xld, don't take offense and he's usually right!!!
    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)

  6. #6
    Quote Originally Posted by Simon Lloyd
    Dave - beware of this one!, discussions can get more than interesting but whatever you do when having discussion with xld, don't take offense and he's usually right!!!
    Ya, I caught that right away from reading some of the responces he was involved in

    I've got thick skin so I think I'll be ok but thank you for the warning
    What happens if you get scared half to death twice?

  7. #7
    Quote Originally Posted by xld
    Pretty interesting? I have been here 5 and a bit years, and I find at least one a day more than interesting.

    It's the best VBA site for Excel, bar none.
    Ya, pretty interesting. I've been browsing thru some posts yesterday and this morning and have already realized that I'll be able to learn alot. I am also hoping that I'll be able to share some of my limited knowledge with others too.
    What happens if you get scared half to death twice?

  8. #8
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by davmec93
    What happens if you get scared half to death twice?
    You would be three-quarters dead!
    ____________________________________________
    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

  9. #9
    Quote Originally Posted by xld
    You would be three-quarters dead!
    Now that is the correct answer!
    What happens if you get scared half to death twice?

  10. #10
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Well I'll be blowed..... He didn't write that as a function.
    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. #11
    Quote Originally Posted by Aussiebear
    Well I'll be blowed..... He didn't write that as a function.
    Now thats funny

    I think I'm going to like it here!
    What happens if you get scared half to death twice?

  12. #12
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Quote Originally Posted by Aussiebear
    Well I'll be blowed..... He didn't write that as a function.
    Yep, i know but i'll bet he used SUMPRODUCT

    Davmec93, when you get to know xld he can make sumproduct do almost anything except make tea and buy a round!
    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)

  13. #13
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Quote Originally Posted by Simon Lloyd
    Yep, i know but i'll bet he used SUMPRODUCT

    Davmec93, when you get to know xld he can make sumproduct do almost anything except make tea and buy a round!
    Please don't tempt him....
    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

  14. #14
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by Simon Lloyd
    Yep, i know but i'll bet he used SUMPRODUCT

    Davmec93, when you get to know xld he can make sumproduct do almost anything except make tea and buy a round!
    After giving you a SUMPRODUCT solution, I expect you to buy the round!
    Last edited by Bob Phillips; 10-08-2010 at 07:50 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

  15. #15
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Quote Originally Posted by xld
    After giving you a SUMPRODUCT solution, I expect you tobuy the round!
    I believe you are right (didn't i mention you're always right?)

    So the next conference i can make (or host ) i'll be pleased to help you on your way to a few damaged brain cells (we'll see how unclever i can make you!).
    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)

  16. #16
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by Simon Lloyd
    I believe you are right (didn't i mention you're always right?)

    So the next conference i can make (or host ) i'll be pleased to help you on your way to a few damaged brain cells (we'll see how unclever i can make you!).
    My philosophy is that the number of beers I can get in before I go is not going to do me as much harm as the ones I have already had, so no worries!
    ____________________________________________
    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

Posting Permissions

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