controlling sheet number not sheet name

[wagee]

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

 

[Leith Ross]

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

 

[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