help!generate random number using in xlw

[huang11404]

i want to get a random number generator. i know how to generate random number in c++. however, when i build in xlw, generate an xll file and open in the excel, it still generate the same number, since i drag excel spreadsheet.

does anyone know how to generate random generator in excel, just like the excel build-in function random(), which can generate random number in each excel grid.

thanks very much!