Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling sheet number not sheet name
Hi all,
I have a sheet, it is sheet169 (Well Data). I copy this sheet as a template to another workwork and rename it from sheet169 (Well Data) to sheet169 (SomeOtherName). Sheet169 will get copied over and over again to the same workbook each time incrementing by 1. Am I correct in assuming the limit is 255 sheets in a workbook? if so I need to reset this sheet number to 1 instead of 169. It can be a manual task, does need to be in VBA but it is VBA that is doing the copying..... Wayne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling sheet number not sheet name
On Jul 26, 9:38 am, wrote:
Hi all, I have a sheet, it is sheet169 (Well Data). I copy this sheet as a template to another workwork and rename it from sheet169 (Well Data) to sheet169 (SomeOtherName). Sheet169 will get copied over and over again to the same workbook each time incrementing by 1. Am I correct in assuming the limit is 255 sheets in a workbook? if so I need to reset this sheet number to 1 instead of 169. It can be a manual task, does need to be in VBA but it is VBA that is doing the copying..... Wayne Hello Wayne, The maximum number of sheets in a workbook is limited by available memory. Sincerely, Leith Ross |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
controlling sheet number not sheet name
On Jul 26, 6:06*pm, Leith Ross wrote:
On Jul 26, 9:38 am, wrote: Hi all, I have a sheet, it is sheet169 (Well Data). I copy this sheet as a template to another workwork and rename it from sheet169 (Well Data) to sheet169 (SomeOtherName). Sheet169 will get copied over and over again to the same workbook each time incrementing by 1. Am I correct in assuming the limit is 255 sheets in a workbook? if so I need to reset this sheet number to 1 instead of 169. It can be a manual task, does need to be in VBA but it is VBA that is doing the copying..... Wayne Hello Wayne, The maximum number of sheets in a workbook is limited by available memory. Sincerely, Leith Ross Thanks Leith that is good to know. Wayne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
Controlling sheet number during sheet add | Excel Programming | |||
Controlling tab order on a sheet to include AX combos | Excel Programming | |||
Creating and Controlling a User data Entry Sheet | Excel Discussion (Misc queries) | |||
Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions |