View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default application.run on new sheets created

na. not what i'z doing.

i even tried laying it out this way (to run it on the same sheets that
were going to be created) and didn't work.

Sub nn()
For x = Sheets("IND_BRKDWN").Index + 1 To Worksheets.Count
Call PASTE_COUNT
Call AAA
Call printareamacro
Next
End Sub