for a better answer, you need to post your code with a clearer explanation
of what you want to achieve. You imply that the code is moving between
sheets now, using either of the solutions offered may work or they may not
depending on how your macro determines where to paste the information. It
sounds like you might want some type of consolidation macro, in which case,
just wrapping a loop around your existing code might not be the whole
solution.

--
Regards,
Tom Ogilvy

"Dominique Feteau" wrote in message
...
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?