This works really well, but you have to turn on the VBA support in the Tools_Add-Ins... (The Analysis ToolPak-VBA and the Internet Assistant VBA) This makes a great random generator for gems and jewlery.
Great idea, and it would be a handy utility, but I never could get it to work. I checked the boxes, and it tried to to generate values, but it never displayed anything but "#name" or "value". Was something missing in the download?
Rating:
[2 of 5 Stars!]
Creator Reply:
Steve, Make sure you have the two VBA Analysis Toolpacks in stalled (go to Tools > Add-Ins). If it still wont work for you, drop me a line, and I'll see if I can't figure out what's happening for you. Regards, Jim Kramer kramer@usherwoodadventures.com