Search results

Hi Marc L, Rnd function in VBA not able to produce good quality random numbers compare to RNG Mersenne twister. I am looking for good quality RNG like Mersenne twister OR Marzam II. Actually I just copy this codes from a book. I am not able contact the author. My questions :- 1) The...

Hi, Someone sent me this codes. Is it VBA codes ? Is it for random number generator ? Public i97, j97, u(97) As Double, c As Double, cd As Double, cm As Double, uni As Double Public Sub Init() Dim i, ii, j, k, ij, kl, l, m, jj, ivec, i5, j5, s As Double, t As Double ij = Seed1 kl = Seed2 i...

Hui, It works ! Thanks James

Hi, Actually I have two excel files, namely :- 1)EasyFitXL-TRY1.xlsm 2)EasyFitXL-TRY2.xlsm Both file have the same macros(100% same ! I just copy all macros from ***-TRY1 to a new file ***-TRY2 !). However, macro for file EasyFitXL-TRY1.xlsm can be ran smoothly but macro for...

Hi Deb, Can I send the excel file to you and then you check for me ? James

Hi Narayan, Can I send you the excel files and then you check the macro for me ? I have to send you the add-in program from mathwave.com to you as well or you can download from mathwave.com : http://www.mathwave.com/downloads/easyfit-setup.exe Your email address please. James

Hi Hui, I have sent them an email and waiting for their reply. Is there any problem with my macro ? James

Hi , 1)I am using WINDOWS VISTA, M.S EXCEL 2007. I have installed an EXCEL Add-In program call EasyFitXL(from www.mathwave.com) to my computer. My VBA codes are as follow :- Sub Easy6() EasyFitXL.Randomize seed:=0 Rnum = EasyFitXL.UniformRand(0, 1) Range("a1").Value = Rnum End Sub...