Have a macro which runs 3 submacros. What do I use to have this macro repeat itself a specified number of times?
Here's the macro:
Sub Extract1()
'
' Extract1 Macro
' Macro recorded 4/5/2002 by Hans
'
'
Application.Run "'Address Retriever2.xls'!Extract"
Application.Run "'Address Retriever2.xls'!SelectRange1"
Application.Run "'Address Retriever2.xls'!Distribute"
End Sub
Hans
Here's the macro:
Sub Extract1()
'
' Extract1 Macro
' Macro recorded 4/5/2002 by Hans
'
'
Application.Run "'Address Retriever2.xls'!Extract"
Application.Run "'Address Retriever2.xls'!SelectRange1"
Application.Run "'Address Retriever2.xls'!Distribute"
End Sub
Hans