Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default numbering new sheets with the same number

Hi

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

can anyone help

thanx
NICK
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default numbering new sheets with the same number

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.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"NICK" wrote in message
...
Hi

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

can anyone help

thanx
NICK



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default numbering new sheets with the same number

...is not possible as you cannot have sheets with same number or name.

Tom
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbering Sheets albertmb Excel Discussion (Misc queries) 3 November 21st 07 01:11 AM
Page numbering of multiple sheets JHJ Excel Discussion (Misc queries) 1 May 30th 07 04:19 AM
Numbering Sheets incrementally (as in Invoice numbers) Steve Excel Discussion (Misc queries) 1 December 13th 06 01:36 AM
Numbering Multiple Sheets derek Excel Discussion (Misc queries) 3 May 4th 06 02:48 AM
Numbering sheets in workbook Red Excel Worksheet Functions 3 March 2nd 05 08:10 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"