Used to change the seed value used by the random number generator for the Rnd function.
Simple Randomize Examples
Sub Randomize_Example() Dim randomValue Randomize randomValue = Rnd End Sub
In the VBA Editor, you can type “Randomize(” to see the syntax for the Randomize statement:
The Randomize statement contains an argument:
Number: [Optional] It is a numeric “seed” that will be used by the Rnd function to generate a random number.
VBA Coding Made EasyStop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!