Call "another Macro" multiple times

Hi,

Quick question, can you use

Call macro name

multiple time based on a Cell Value within a worksheet?

Obviously my printer is too ancient to be able to print multiple copies at once so a work around would be to call the Print macro as many times as required based on a cell value within the worksheet.

Let me know what you think

Many thanks

simon

I had another thread about this idea as it was not working

http://www.excelforum.com/excel-prog...52#post3144052

Maybe use a Loop?

Sub SimonWard()
Dim x As Long

x = Sheets("Selection").Range("E27").Value

Do Until x = 0
    Call MacroName
    x = x - 1
Loop

    
End Sub

Ahh ok thanks

You're welcome. Hope it helps.