RAND VBA code build on itself?

**Rick-O-Shay** · 01-05-2011, 09:05 PM

Hello,

Here is my code:

Please Login or Register  to view this content.

What I need to know, is how to make cell C3 build on itself, for example, every time the macro is run, the random # is randomly added or subtracted

i.e.

C3 = 1 the macro increases 1 by 2.3456 to equal 3.3456
the macro is run again and it (randomly adds or subtracts) by 2.3456
Now C3 = 1

**shg** · 01-05-2011, 09:17 PM

Maybe ...

Please Login or Register  to view this content.

**Rick-O-Shay** · 01-05-2011, 11:14 PM

That is great! But I need the number to be randomly positive or negative. Any ideas on that? So that the number in the cell will go both up and down.

**shg** · 01-06-2011, 12:43 AM

Please Login or Register  to view this content.

**Rick-O-Shay** · 01-06-2011, 11:30 AM

SHG, your the BEST! Now 1 last question on the matter Is there any way to make it so that

1. Cell C3 never goes below 0

and

2. There is a slightly higher (lets say 55%) chance that the random # will be positive instead of negative?

**shg** · 01-06-2011, 11:39 AM

Please Login or Register  to view this content.

**Rick-O-Shay** · 01-06-2011, 11:44 AM

You the man shg.

RAND VBA code build on itself?

LinkBack

Thread Tools

Rate This Thread

Display

RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Re: RAND VBA code build on itself?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions