Go back to created sheet

Giganews Newsgroups
Subject: Go back to created sheet
Posted by:  Mercury (pulgar…@bellsouth.net)
Date: Sat, 4 Oct 2003

This macro creates a new sheet, lets call it "sheet1" to insert a pivot
table. Then it returns to the data sheet, let's call it "main" ,does clean
up, then stops. Since the new sheet, sheet1, may have different names all
the time, ie. sheet2, sheet3, etc..
How can I get the macro to go back to the new sheet? I need the code set up.
Also, at what code location do I insert the screenupdate=false to stop it
from flashing the screen?

Thanks.

Replies