I'm working  on a program  that will take a main  page of data  and
seperate it into individual  named worksheets  according to a main
attribute.

Then the program will perform  a variety of tasks on each worksheet
(including creating  a named  range on each sheet  depending on the
number of lines  of data).

I will be updating  the main data page  periodically and wish to have
the program do all the subsequent dirtywork. The updates  may add  or
delete categories so my worksheets and graphs  can't reference  static
cell blocks.

When I attempt to use the program on updated  material, I must delete
all previous  pages and named ranges  to avoid  creating a page or range
with a duplicate  title.

I'm hoping there's a simple  command that would perform this function:

If worksheet(name) exists, then delete  worksheet.

A simple "worksheet(name).delete" command  will give  me an error  if
there is no worksheet  with that name. Likewise, "worksheet(name).add"
causes a duplication if the old worksheet hasn't been deleted.