newly added sheets and incrementing sheet 'numbers'

  • Thread starter Thread starter crichardson
  • Start date Start date
C

crichardson

I have a spreadheet where I'm adding worksheets via vba. I delete ol
worksheets to tidy up before creating new ones. I give the ne
worksheets a useful name. However, I notice in the vba project view i
the vba editor that the underlying sheetname keeps incrementing (eg
Sheet999) despite the fact that the old sheets have been deleted.
Although this isn't stopping things from working, I think it would b
better to reset the sheet 'numbers' back to a reasonable startin
point.

Is there a way to make excel choose the lowest available sheet number?

Regards,

Cliv
 
Excel pretty much does what it does.

If you want to change the code name of the sheet(s) in code, you can
probably do that although there are KB articles that advise against it. I
believe you have to use the properties property to actually do the name
change.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel crashes and restarts when accessing newly created worksheet 2
Search other sheets for numbers & color them 10
clear all sheets code 4
sheet numbering system 1
Controlling sheet number during sheet add 3
stop added worksheet becoming active 4
Worksheet Number Max 3
controlling sheet number not sheet name 2

Back
Top