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.