+ Reply to Thread
Results 1 to 2 of 2

Error #value!,

  1. #1
    Registered User
    Join Date
    04-01-2023
    Location
    Canada
    MS-Off Ver
    recent
    Posts
    1

    Exclamation Error #value!,

    __________________
    Last edited by glimbo_box; 04-01-2023 at 03:17 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Error #value!, vba code trinomial model , option put american

    Welcome to the Forum glimbo_box!

    To answer your question we need to know:

    What are the inputs and what is the output for this function and how does it work? This is very cryptic code.
    What are the argument values that are causing the error?

    Ideally you should attach your Excel file with sample data so we can run the code in your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Solver Macro giving "Error in Model Message". SetCell not updating after running code.
    By maxleolind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2020, 09:50 AM
  2. Option Pricing Model - Solver / User Defined Function
    By purpleeagle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2020, 04:11 PM
  3. [SOLVED] Excel 2016 VBA - Declaring statement - code works without Option Explicit & Error handling
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2018, 08:52 PM
  4. error in macro code with variable option
    By Macro_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2014, 09:16 PM
  5. last option not done in this code error is duplicate intregate
    By vipultejani in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 07-16-2014, 03:17 AM
  6. [SOLVED] Code to hide cells when option button chosen error
    By lindafinlay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2014, 11:50 PM
  7. Basket Option Pricing Model (Excel/VBA) - help needed for multiple loops of arrays
    By haven83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2012, 02:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1