With selection - randomly call 1 of 4 macros in each cell.

[Oriya]

Hello,

I'd really like some help with this because I've got no idea how to deal with the code that randomises anything in VBA.

I'd like some code that (with the selection) will cycle through cells and randomly call 1 of 4 macros in each cell. Can anyone help with that please? I've honestly got no idea where to start.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[Kaper]

The question is reather vague, especially without a sample file (see yellow banner near the top of the page)
you may start with something similar to:

Please Login or Register  to view this content.

How to test it: select range C5:C8, press Ctrl and select another range like E8:E11 and run this macro (test) you shall see something like (althought numbers will be different, as it is random process) the attached screenshot