Hi,

Apologies if this is quite a simple query, however VBA is very new to me.

I am wanting to loop my formula so that when my marco button is pressed, the formula will run in the same cell 50 times.

The formula is for a random name selector and I am wanting to achieve the impression that the selector is cycling through the list of names until it stops running after the 50th time.

So far I have the following macro which is working:

Sub Enter_Formulas()
Range("D4").Formula = "=ROUND((RAND()*'List'!C4)+0.5,0)"


End Sub

How do I now go about looping this?