Hex Code Generator

[pwyller]

I need a VBA macro that will do what this formula does, but I need to be able to populate a variable selection of cells:

=CONCATENATE(DEC2HEX(RANDBETWEEN(0,65535),4),"-",DEC2HEX(RANDBETWEEN(0,65535),4),"-",DEC2HEX(RANDBETWEEN(16384,20479),4),"-",DEC2HEX(RANDBETWEEN(32768,49151),4))

This generates a random hex code like this: F117-F025-4990-91E4

Thanks!

I have this:

Please Login or Register  to view this content.

but it re-iterates the same groups over and over.

[MrShorty]

This forum can be strict about some of its rules, like putting code within code tags. You risk having your topic locked if you fail to comply.

At this point, I will say that I did not recreate the problem. It seemed to generate several random sequences without repeats, so I suspect something else is going on. You might need to describe in more detail what is happening and not happening so that we can recreate the problem.

[pwyller]

When you select 32 cells and run the macro, the second 16 are repeats of the first 16 cells.

[MrShorty]

When I select 32 cells and run the macro, I get 32 unique entries. I tested in a nearby column with =COUNTIF(A$1:A$32,A1) copied down, and all results are 1.

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your opening thread title to something that better explains your problem. Thanks!