FilippoCuneo
New Member
- Joined
- Jul 27, 2010
- Messages
- 3
Hi ! I'm Filips and i speak english like my dog !
I've many problems with indirect command and SimSheet Simulations tool !
SSOutputStream("NPV";Indicatori!F57;INDIRECT("R"&Simulazione!L13*(Simulazione!N17-1)+7&"C"&Simulazione!L14+9;FALSE))
This is the command line that destroy my balls!
SSOutputStrem works like this example :
SSOutputstream(LABEL;Recorded Cell;Output Cell)
ok.. when i wrote the command and i want to use the same sheet,all works perfectly !
Unluckily i must record 1kk numbers and i must record outputs on another sheet because my pc/mac crashes !
I've tried with this [Output.xlsx]Dati!
So I used this command but doesn't work !
=SSOutputStream("NPV";Indicatori!F57;INDIRECT('[Output.xlsx]Dati'!"R"&Simulazione!L13*(Simulazione!N17-1)+7&"C"&Simulazione!L14+9;FALSE))
I hope that u can help me because i'm very nervous and i drop my pc out of windows if the program doesn't work !
Thanks a lot !
Bye
PIPPO !
I've many problems with indirect command and SimSheet Simulations tool !
SSOutputStream("NPV";Indicatori!F57;INDIRECT("R"&Simulazione!L13*(Simulazione!N17-1)+7&"C"&Simulazione!L14+9;FALSE))
This is the command line that destroy my balls!
SSOutputStrem works like this example :
SSOutputstream(LABEL;Recorded Cell;Output Cell)
ok.. when i wrote the command and i want to use the same sheet,all works perfectly !
Unluckily i must record 1kk numbers and i must record outputs on another sheet because my pc/mac crashes !
I've tried with this [Output.xlsx]Dati!
So I used this command but doesn't work !
=SSOutputStream("NPV";Indicatori!F57;INDIRECT('[Output.xlsx]Dati'!"R"&Simulazione!L13*(Simulazione!N17-1)+7&"C"&Simulazione!L14+9;FALSE))
I hope that u can help me because i'm very nervous and i drop my pc out of windows if the program doesn't work !
Thanks a lot !
Bye
PIPPO !