Macro sentence syntax?

[eliW]

Hi all,

In my macro I have this:

.Fill.ForeColor.SchemeColor = 13

Now I want to replace the fill forecolor number "13" with a random number

How do I do this using: RANDBETWEEN(1,50)

Eli

 

[GlennUK]

Just replace it. BUT, remember to add-in the Analysis Toolpak VBA add-in, AND add the VBA reference ( in the VBE ) atpvbaen.xls reference.

 

[Andrew Poulsom]

Or maybe:

Int((50 * Rnd) + 1)

 

[eliW]

So simple
Thank you Glenn & Andrew.
Eli