Overwrite or Replace existing Worksheet with VBA

[Davidp06]

Hello all!

I am really banging my head on a wall....
I have a macro, that generates a worksheet based on the users input. It generates to a template worksheet, and is then transfered to a
"dumbed down" worksheet. The problem is, they can, and do, initiate the same search twice. This results in a "Run-Time" error. Here is the
bit of code that transfers the data from the "Template".
The Template is named based on the users query. Ex: Input Query (value1) is "Hammer", sheet transfer name is "Hammer-DATA"
ANY and ALL help would be appreciated!!!!

Thanks

Please Login or Register  to view this content.

[JBeaucaire]

So you want to be sure the macro doesn't try to create Hammer-DATA a second time? Something like this, perhaps:

Please Login or Register  to view this content.

[Davidp06]

Thank YOU!! I know i was just looking at it from the wrong direction!!!