Good evening Carl
The problem is that you're DIMming the variable rng twice and that's
not allowed. That's not to say you can't load rng twice with two
different values in the same routine - obviously, providing the first
value you load in there is no longer needed.But only DIM it once. If
you want two distinct values you could call the second rng variable
rng1, and remember to change subsequent lines to make sure that they
call the right variable.
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=383269