Thank you. Worked Perfectly and will save me a great deal of time.

Thanks again

"bpeltzer" wrote:

Worksheets("Sheet3").Select.
You could also replace the string literal with a variable set to the name of
the desired sheet.

"John" wrote:

When i have written Macro's to take you to another sheet, I always write

ActiveSheet.Next.Select

However I am getting too many sheets. Is there an easier way to write a
macro to take you directly to another sheet without having to write the above
statement 15 times?