macro to set bottom and top values for randbetween
Hi Tonso,
Am Wed, 3 Oct 2012 08:16:55 -0700 (PDT) schrieb Tonso:
The macro works great if a single cell is selected. If more than 1 cell is selected, the value in eery cell is the same. I need to have a different value returned for each cell selected, whether it is a singel cell, or serveral or more cells.
try it with:
Selection.Formula = "=randbetween(" & [A1] & "," & [B1] & ")"
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|