View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Berj Berj is offline
external usenet poster
 
Posts: 28
Default MACRO in a Loop Problem

Dear Anybody.

Consider this code:

Sub Macro41()
' Print ALL

Dim counter As Integer
For counter = 1 To 5
Call Over
Call Macro(counter)
Call Last
Next counter

End Sub

A few problems-
1. I want to address Macro1, Macro2, Macro3 €¦ but it it gives me an error on
the Call Macro line. How can I make it work?
2. I want the number 5 (final value of the loop) to be the contents of C2
cell of the current sheet and file the Macro41 is in.


Thanks in Advance.