I have this line of code which I want to concatenate -or at least solve the loop problem...
test = 1 - ("0." & thisnumber(0) & thisnumber(1) & thisnumber(2))
I want this to have a loop in it...
-Increasing thisnumber()
Until it gets to about 500,
Can some implement a loop into this?
Or suggest a way...
Thanks a lot..
James :)
EDIT:
So if I had values thisnumber(0) = 1, thisnumber(1) = 5, thisnumber(2) = 0, thisnumber(3) = 7... It would do 1 - 0.1507... (But I want a loop so it does all 500 without me typing them all out) -I'm wanting 1,000,000 so it would be a huge problem.