Set StartSheet = Activesheet

'your code

StartSheet.Activate

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jim" wrote in message
...
Hi. I created a Macro to take a excell file (lets same its named Doggy),
sort and break up per my specs and place results on 7 different tabs.
Works
good. However everytime I get a new file to convert through this Macro I
have to rename the file to Doggy before the macroo will work because that
is
the name on the tab when I origionally created the macro. Here is the
line
that is causing the issue - Sheets("Doggy").Select . is there a way around
this?

Thanks