Read the tips of John Walkenbach: very usefull!!!!!!

http://spreadsheetpage.com/index.php...vba_functions/

Success!!!

--
met vriendelijke groetjes


"Scott" schreef in bericht
...
I have a macro that, depending on the data, will sometimes create a
separate
sheet entitled "MC TABLE". I also have a second Macro within the same
program
that will delete and clear the needed sections of the different worksheets
so
that it can be ready for the next batch of data on the next day. The
problem
is that the "MC TABLE" sheet needs to be deleted entirely but on the
occasions that it does not exist, I get an error message. How can I write
the
code so that it tests to see if that sheet exists before attempting to
select
or delete it??