Excel not responding

[shahdelsol]

I created a workbook 3 years ago and since then each month I have been adding a new tab. I currently have about 36 tabs. All tabs are identical size which they are from A1 to AP69. Not every cell has data but most of cells has something in it so I don't think it is necessarily a big file. Every month I have been copying last tab or one of tabs to create a new tab and add new data. There hasn't been any problem until recently when I am trying to copy new tab and add to the end of tabs I get " Excel not responding" like there is lack of memory or something and goes for ever. One time I didn't cancel and let it go and finally after a few hours it created a new tab. My question is : Is this lack of memory? To me This is not a big file and I have only 36 tabs and tabs/sheets are not big file.

I have also hidden the rest of cells beyond A1 to AP69 and I don't know if this matters or not. My Excel is Home and business 2016 version. ​

Does anyone know why it takes this long?

 

[shahdelsol]

It really must be the first code I shared. Because if I remove it, the problem goes away

That looks ok as well. So not sure what happened.
Best bet is keep a backup copy of the file, and regularly monitor the new working file to see if it happens again.

 

[Fluff]

Are you saying that when that code runs the last cell becomes XFD1048576?

 

[shahdelsol]

I thought yes but now I have been done more testing maybe not. I deleted a sheet with problem and recreated a new one and it seems working fine for now. I might end up redoing all the sheets.Thank you again for all help.

Are you saying that when that code runs the last cell becomes XFD1048576?

 

[Fluff]

You're welcome & thanks for the feedback