Looping a Formula?

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?

Thanks Pete. I have updated my module with the above, however now when I run the Marco, loads the "Open File" window each time before completing the calculation. Any idea how to get around this?

Thanks for the advice about the code tags

Dan

There is nothing in that code that should cause the Open File dialogue to open. Perhaps you have something else in your module?

Pete

Hi Pete,

My module now reads as follows:

Please Login or Register  to view this content.

The Dialogue box which opens says "Update Values: List" at the top of the window

The only way I can reproduce that is if the sheet that is named List has a space (or more) at the end of the name. Double-click on the tab and type List again without any spaces, then you can re-run the macro.

Hope this helps.

Pete