View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dominique Feteau Dominique Feteau is offline
external usenet poster
 
Posts: 34
Default Using a macro over a number of sheets

I have this small macro that i recorded that does a few small functions
including copying & pasting a small bit of info from one sheet onto another
sheet. The thing is that I have to do this to about 50 sheets. Is there a
way to have the macro jump to the next sheet and do the same thing
automatically?