numbering new sheets with the same number

  • Thread starter Thread starter NICK
  • Start date Start date
N

NICK

Hi

i need to know how to number new sheets with the same
number as previous ones

can anyone help

thanx
NICK
 
Nick,

I'm not sure what you mean. You can change the name of a sheet with code
like

Worksheets(2).Name = "NewName"

Perhaps you could provide a few more details about what you want to do.
 
...is not possible as you cannot have sheets with same number or name.

Tom
 
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

New WorkBook With Specified Number of Sheets 1
Search other sheets for numbers & color them 10
Search an array of sheets for an array of numbers & return count of numbers 11
Find Specific Rows in Range and Create New Tab 18
Excel Drag autofill only part of formula 3
Excel vba code to match duplicates 4
Runtime error 1004 when trying to insert formula in cells 11
Reduce Numbers Down To A Specific Value 1

Back
Top