+ Reply to Thread
Results 1 to 5 of 5

Monte Carlo to output two or more variable to a new spread (partially worked)

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    California
    MS-Off Ver
    MSO2010
    Posts
    3

    Monte Carlo to output two or more variable to a new spread (partially worked)

    Hello all. I have a working script that exports a variable from "Calculation" sheet- located in cell M22, from a monte carlo sim to "Sheet2". This script works as is, and is part of a chain of subs. What I really need help with is getting this script to export the variable on the "Calculation" sheet located at L31 along with it.

    I would like to output the variable from L31 into column B on Sheet2. I have not addressed the output of the single working variable yet, as I don't know how, but it does automatically go to A1.

    If someone could point me in the right direction, I'd greatly appreciate it.

    Thanks!

    VBAnewbie

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Monte Carlo to output two or more variable to a new spread (partially worked)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-26-2014
    Location
    California
    MS-Off Ver
    MSO2010
    Posts
    3

    Re: Monte Carlo to output two or more variable to a new spread (partially worked)

    I inserted it below:
    Please Login or Register  to view this content.
    It returns a "Subscript out of range" error.

  4. #4
    Registered User
    Join Date
    08-26-2014
    Location
    California
    MS-Off Ver
    MSO2010
    Posts
    3

    Re: Monte Carlo to output two or more variable to a new spread (partially worked)

    Bump for a solution. Really need someone's help.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Monte Carlo to output two or more variable to a new spread (partially worked)

    If the workbooks are the same then why refer to them?

    Do you have sheets named "Sheet2" and "Calculation"

    Have you set the variable i?

    why have you not used .value? I appreciate sometimes you don't need to but try this first:-

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-27-2014 at 07:28 PM.

+ 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. Monte Carlo constraints
    By Hereward in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2013, 08:27 AM
  2. Monte carlo
    By karan21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2011, 04:06 PM
  3. Monte Carlo & solver
    By dabrows in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2011, 08:53 PM
  4. How can I create a monte carlo from a monte carlo?
    By rrbest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2010, 03:06 AM
  5. Monte Carlo Simulation
    By wmfinance in forum Excel General
    Replies: 3
    Last Post: 07-13-2010, 01:33 PM

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