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

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

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