AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Excell 2011 for mac keep freezing11/9/2023 ![]() ![]() Therefore, at the very moment that my freeze panes function was "shooting", the top 10 rows of my worksheet were actually out of the visible range (of course, everything inside a routine running as fast as the wind and with excel powers -such as screen updating- being turned off etc.) which caused an issue because these rows always remained like blocked out of the visible range after running the procedure. My problem was that in the moment that my code was trying to freeze the window in panes, the groups moved around without myself having noticed it. ![]() ![]() I have spent more than an entire hour to understand what was wrong with my code, and finally I think I've got it. Coding with both a structured worksheet (with rows and/or columns grouped) may be tricky.
0 Comments
Read More
Leave a Reply. |