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

On Jul 26, 9:38 am, wa...@btinternet.com 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

On Jul 26, 6:06*pm, Leith Ross <LeithR...@gmail.com> wrote:
> On Jul 26, 9:38 am, wa...@btinternet.com 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