Repeat macro from user input

Hi,

I have a very simple macro for recalculating formulas and printing the page.

I need a way to show an input box where the user can say how many times to repeat the process i.e. 2x = recalculate, print, recalculate, print.

Thanks in advance

Edit: The input number needs to be rounded to even then halved before repeating

Can you post your code - remember to use Code Tags

What's the purpose of it? Calculation is automatic unless you have switched it off in Options. tt uses an Excel4 macro and I don't know how you recorded that.

The purpose of it is the recalculate several RANDBETWEEN formulas so each page printed is different. I recorded it in the usual way by pressing record macro, pressing F9, Control P and enter.

Edit: SImply printing 50 copies produces the same sheets wihtout recalculating the forumlas in between copies

What version of Excel are you using?

This should do what you want

Dim n      As Integer
    Dim x      As Integer
    n = Application.InputBox("How many copies?")
    If n > 0 Then
        For x = 1 To n
            Calculate
            ActiveSheet.PrintOut Copies:=1, Collate:=True
            End If
        Next x