i created a macro which provides three random numbers a1:a3.

i now need to create another which can hold the doubles that show on a1 and a2.

i tried creating a seperate macro button generates random number in a3 but for some reason it randoms cells a1:a3 again.

any help how to configure this in excel, macro or no macro?

any help how to configure this in excel, macro or no macro?

First step is to post your request to an Excel forum. This forum is dedicated to Access relational databases.

Best wishes - Bob