Excellent! That works. Many thanks
Keith

"JE McGimpsey" wrote:

You can add an unlimited (well, limited by your machine's memory) number
of worksheets, but only 255 at a time. You can't reset that max.

If you have a workbook with 255 sheets, you can select 45 sheets and
choose Insert/Worksheets to get to 300.



In article ,
"Hoochi Coochi Man" wrote:

I need to increase the total number of worksheets beyond the 256 max. I have
seen some code to do this in other threads but I dont know where to begin
with actually entering it! Be v. grateful for a step-by-step advise on
resetting the max, say to 300 or 350.