Macro is deleting sheet, and I would like it to clear contents

I am using a borrowed macro to autofilter for me. The macro does exactly what I want it to, with one exception. It deletes and recreates a worksheet page everytime you run it. I think I would like it to just clear contents instead of delete. I am trying to copy the data from the filter to an invoice sheet, but it keeps returning a #REF! error because the sheet is deleted and recreated each time I run the macro. I tried changing the .delete to a .clearcontents, but then it has a problem with creating a sheet with a name that is already being used. I'm rather new at macros and need some help with this. Thanks....The macro is:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time but read the rules before you post again

You must have the sheet("MyFilterResult") to copy to

Please Login or Register  to view this content.

I don't think you copied all the relevant sections of Roy's code. You're still trying to create the worksheet again.

It's a help to say what line the error occurs on.