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?
Bookmarks