25 Jul 2006 at 18:55 #1 StevenG StevenG Soldato Joined 25 Jan 2006 Posts 3,071 Location Gateshead, Newcastle Excel Random Code. i need to code to generate a rndom number between a set of numbers e.g. 1-12
25 Jul 2006 at 22:18 #2 Volcs Volcs Associate Joined 6 Nov 2004 Posts 2,498 Location Angel If you have the Analysis ToolPak installed then you can use =RANDBETWEEN(lower#, higher#).