copying sheets

ilspensoroso

Board Regular
Joined
May 8, 2002
Messages
52
I have an excel worksheet which I use as a template in a workbook. Each week I copy the sheet and rename it. It has now been copied 25 times. Is there a limit on copying sheets because this sheet will not copy anymore.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
680
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
What you are getting while copying 26th time?

GNaga
 

ilspensoroso

Board Regular
Joined
May 8, 2002
Messages
52
Nothing. The sheet which I call BLANK does nothing. It used to become BLANK (2) and I would then change the name to the current weekending.
 

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
680
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
I see. I am not sure. As far as I know 25 times copying should not be the problem.

GNaga
 

chef

Well-known Member
Joined
Jul 10, 2002
Messages
561
Office Version
  1. 365
  2. 2016
You should be able to copy more than 25 times but you may not be able to display all these tabs at the same time....it has probably copied but not visible.

try using the arrow keys next to your tabs at the bottom of your worksheet to display more sheets unti you display the one you want

regards
chef
 

ilspensoroso

Board Regular
Joined
May 8, 2002
Messages
52
Thank you Gnada and Chef,

In the project window of VBE there are only 25 copies However, the project window looks like a large triangle starting with the first copy extending out and down to 25
 

Watch MrExcel Video

Forum statistics

Threads
1,123,103
Messages
5,599,740
Members
414,333
Latest member
willfrederick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top