|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?