Range expanding each time Rows are added and then deleted

  • Greetings.


    I have a weird issue on 1 specific excel file. I created a new working based on a pre-created template I use for all my workings, and while all others work fine this particular one has the following problem:


    I have my Working Area set to Row 104 and everything after that Hidden. If for example I add 2 lines after line 80 my active sheet correctly renumbers my last row to 106. If I now delete these 2 added lines, my previous last row is renumbered to 104 correclty, however 2 rows are also unhidden and the Working Area remains as up to row 106.


    Again as I have stated this issue is not present in my other Workbooks/Worksheets which are based on the same template.


    Does anyone have a solution to this problem? I wish for my Working Area to dynamically change and keep my original 104 row as last.

  • Re: Working Area expanding each time Rows are added and then deleted


    Thanks for the reply!


    I have attached a sample of my schedule. If you delete rows using my Delete button on table 1 (I have a security check so not everything can be deleted) you will notice that the amount of rows deleted will appear at the bottom after row 104. Similarly if you add rows and then delete them the same thing happens.

  • Re: Working Area expanding each time Rows are added and then deleted


    So I noticed that all my schedules are now doing this that were created from my latest template. Haven't solved the issue yet.

  • Re: Working Area expanding each time Rows are added and then deleted


    Just to let you know I've had a look at this, I can see the issue but nothing was immediately obvious. There's a little pressure on my time today so perhaps someone else will be good enough to pick this up.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!