copy sheet

ilspensoroso

Board Regular
Joined
May 8, 2002
Messages
52
Hi all

Each week through a long proceedure,which is split(over 64K), I copy a formatted sheet called BLANK. It then becomes BLANK(2) and returns to BLANK when BLANK(2)is renamed. But no more!!!! Is there a limit to the number of times a sheet can be copied? If so is there a solution?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
What do you mean by 'It returns to blank' ? I seem to remember there was a bug in Excel 97 about copying a sheet, but, I think that also depends where are you copying it.
 

ilspensoroso

Board Regular
Joined
May 8, 2002
Messages
52
Each employee, of which there are 35, is issued with a Tax Card by the Inland Revenue.An individual weekly and annual record. This is updated in the long procedure and copied to a weekly summary of all employees on the blank sheet.At the end of the proceedure an input box asks for a date for the summary sheet which was named BLANK and BLANK2 reverts to BLANK for next week.
 

Forum statistics

Threads
1,144,148
Messages
5,722,779
Members
422,457
Latest member
Mrmuskins

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