Because you are getting a new worksheet added each time your script runs, and the worksheet name is steadily counting up (sheet1, sheet2, ...), I think it is more likely that you are inadvertently adding one more sheet than you intended. Unfortunately, that would require you posting more of your code for us to confirm...

You could go about it by running through your script and then traversing again all of the worksheets in the workbook, deleting any that you don't want...but why not prevent the unnecessary one from being created in the first place?

So, more code please, and I'll take a look. Try to consolidate it as much as possible while still exhibiting the problem...then post the entire example script.

In reply to Re^3: Deleting Blank worksheets by jrsimmon
in thread Deleting Blank worksheets by Ashes.cfg

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.