Help with @risk - macros

[SlowGo]

Lets say I have simulated values in cell A1,A2 and A3 in excel and then cell A1=B1, A2=B2 and A3=B3

Then i want to sort the results in column B in chronological order after (copy->Paste Special->Values)

I created a macro name called "sort"

Now I want to run an iteration of each row 1,2,3 but I want to run the macro before each iteration...I tried the Simulation settings - > Macros -> "Clicked the "Before each iteration" tab

BUT when I run the similation I get error terms ..anyone know what step im missing?

[dumples]

are you naming the macro the same things that you tell at risk when you check the box?

[SlowGo]

I give it the same name as the name I gave the macro in excel

[whisper]

Originally Posted by SlowGo

Lets say I have simulated values in cell A1,A2 and A3 in excel and then cell A1=B1, A2=B2 and A3=B3

Then i want to sort the results in column B in chronological order after (copy->Paste Special->Values)

I created a macro name called "sort"

Now I want to run an iteration of each row 1,2,3 but I want to run the macro before each iteration...I tried the Simulation settings - > Macros -> "Clicked the "Before each iteration" tab

BUT when I run the similation I get error terms ..anyone know what step im missing?

Do you get error terms? or are you getting an error and going to the debugger?

Are you generating error terms from the @Risk functions? Set up a dummy variable as an output that tests to see if your generating an error term in the variables and have @Risk stop if there are any errors in your output.

[SlowGo]

I am generating error terms


My macro copies information in an excel 3 row by 3 column format into another 3x3 row, colum array, then I apply the copy > paste special > values then sorts the last column..

I want this macro to run in a loop for the number of Iterations I want to perform in @ risk

when I run the macro, it does as I requested, but when I embbed the macro in @risk and then run the scenario, the results in the 3x3 row is what is given in the first row, first column only..and the end result in my output summary is a bunch of error terms

I m sure Im doing somethign wrong but I can't put a finger to it