How to call Macro specific Number of times

[Legacy 185509]

Hi
I am trying to run a loop like 16 times
is there any way I can do it please help me
thank you so much

 

[VoG]

For i = 1 to 16
Call MyMacro
Next i

 

[shabbyporpoise]

you can also look in to
do...while
do... until

 

[Legacy 185509]

Hey Thanks for hint
how can I make my macro run till cell B3 has date of

09/30/2010

I want it to keep calling till date is 09/30/2010

thanks

 

[VoG]

Try like this

Do Until Range("B3").Value = DateSerial(2010, 30, 9)
    Call MyMacro
Loop

 

[Legacy 185509]

Thanks I haven't tried that, I'll try that, but intead I figured something else out but I need to know how to link cell into vba code
like this
is there anyway I link 22 from cell, 22 can be different everytime
like R1 it contain number 22, can I like there?
thank you

Sub Run()
For i = 1 To 22
Call Second_Run
Next i
End Sub

 

[VoG]

Try like this

Sub MyRun()
For i = 1 To Range("R1").Value
    Call Second_Run
Next i
End Sub

 

[Legacy 185509]

Oh man thanks
I didn't put .Value if wish I tried it, can you explain why put .Value
if you can
Thanks

 

[VoG]

The Value property returns the value of a cell.

 

[Legacy 185509]

it didn't work
i get debug error
anything else I can try to fix this error?