Deal or no deal

I am currently designing a workbook that mimicks the behaviours of a well know tv show (deal or no deal)

However i am a little bit stuck.

i need to assign values randomly to the 12 rectangles that are the famous red boxes.

the values are 1p, 50p, £1, £2.50, £5.00, £7.50, £10.00, £15.00, £25.00, £50.00, £75.00, £100.00

and the rectangels are simply rectangle1 to rectangle 12 (i drew that with autoshapes.

here's the file so you can see what i'm on about

Hello Macdave_19,

This macro randomizes the 12 money values. There are no zero amounts or repeats. I placed the values in column "I". If you would like to put these values elsewhere then its no problem to change this. This macro has already been installed in the attached workbook.

Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross