4/13/2023 0 Comments Excel for mac 2011 freeze rowI recorded a macro using the Freeze Top Row command (instead of just Freeze Panes), which gave me this code. Why Ctrl5 When you use hashmarks to count is 4, strike through to mean 5. The Freeze Panes command works normally if I apply it manually. I tried recording another macro to format some cells and also freeze the top row. I have tried shutting down Excel, and even my computer, in case it is some weird bug where something is stuck in memory. I searched the forum here, and found this code which was reported to work. I got that working just fine, but now the panes freeze in the wrong place. It WAS working perfectly, but I wanted some improvements in the insertion of the formulae. The first thing it does is to freeze the top row, then it goes looking for a particular row and inserts some formulae. That was my solution: correct steps to freeze panes programmatically with vba 1.įor a better experience, please enable JavaScript in your browser before proceeding. Excel For Mac 2011 Freeze Row By outlamtiba1989 Follow | Public
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |