View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Using a for loop

Hi,

I have a macro and it uses the for loop

For i=1 to 100
Call Macro2
Next i

Then in Macro2 there is another For loop.

Question = is it ok if the "For" loop in Macro2 uses the variable "i".
Should I declare the variable i in each macro, or declare a unique variable
in each macro.

Thanks for your help