Consulting

Results 1 to 3 of 3

Thread: Code not working!

  1. #1
    VBAX Newbie
    Joined
    Nov 2012
    Posts
    1
    Location

    Code not working!

    Hi, this is my first post. I'm an intern and I've been tasked with writing up a function VBA that does some simple calculations. The math is solid but i keep getting #VALUE! error - This is my first attempt at writing something in VBA so any help would be greatly appreciated.

    pastebin.com/WJhfmDw1

    As you will notice i'm using other previously written functions in that one but they all work so I think the problem lies in the structure of my code.

    Thanks

  2. #2
    VBAX Mentor
    Joined
    Jul 2012
    Posts
    398
    Location
    I think it's better you attach a sample file for testing

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    The WWW is a wonderful powerful tool but it does not allow us to to peer objectively at workbooks or code not available to this forum. May I suggest that if you kindly go to the textbox,click on Go advanced, Manage Attactments and follow the prompts from there, you will find a more natural if not earthy way of getting a workbook that we can follow. And yes, include your code.....

    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

Posting Permissions

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