Problem passing value to function

you need to show us the code where you use the function and how you declare the arguments you are passing into the function

remember to use code tags

Hi.
The code is the following:

Please Login or Register  to view this content.

The way to call the function in excel is the following:

Please Login or Register  to view this content.

The problem comes from the Stock variable. Cell BU35 has a certain value, e.g. 10000 derived from a formula. If in excel I edit the formula it'll show me the 10000 value. But running the code the value for the Stock variable will be zero. If I copy and paste value the 10000 everything is ok.

Hope this helps.
Thanks.
Pedro

I can not duplicate.

Can you post workbook example

For me these are what get passed.

$G$36 0
$H$36 0
$I$36 6599.124
$J$36 13198.248
$K$36 19797.372
$L$36 26243.028
$M$36 26089.56
$N$36 25936.092
$O$36 25782.624
$P$36 19336.968
$Q$36 12891.312
$R$36 6445.656
$S$36 0

which matches the cells in the sheet.

I add some more debug code, which produced the following,

$G$36 0 cini= 7 cfin= 19 stk= 0 rownum= 33 prev= 999
$H$36 0 cini= 8 cfin= 19 stk= 0 rownum= 33 prev= 999
$I$36 6599.124 cini= 9 cfin= 19 stk= 6599.124 rownum= 33 prev= 999
$J$36 13198.248 cini= 10 cfin= 19 stk= 13198.248 rownum= 33 prev= 999
$K$36 19797.372 cini= 11 cfin= 19 stk= 19797.372 rownum= 33 prev= 999
$L$36 26243.028 cini= 12 cfin= 19 stk= 26243.028 rownum= 33 prev= 999
$M$36 26089.56 cini= 13 cfin= 19 stk= 26089.56 rownum= 33 prev= 999
$N$36 25936.092 cini= 14 cfin= 19 stk= 25936.092 rownum= 33 prev= 999
$O$36 25782.624 cini= 15 cfin= 19 stk= 25782.624 rownum= 33 prev= 999
$P$36 19336.968 cini= 16 cfin= 19 stk= 19336.968 rownum= 33 prev= 999
$Q$36 12891.312 cini= 17 cfin= 19 stk= 12891.312 rownum= 33 prev= 999
$R$36 6445.656 cini= 18 cfin= 19 stk= 6445.656 rownum= 33 prev= 999
$S$36 0 cini= 19 cfin= 19 stk= 0 rownum= 33 prev= 999

Please Login or Register  to view this content.