Closed byronwall closed 9 years ago
I will call this closed and let a more specific issue take its place if needed. I went through and added header blocks for all of the modules and Functions/Subs. This should remove most confusion about what things are supposed to do. I am using MZ Tools and Office Automation Smart Indenter to be consistent with sorting, comment blocks, and indentation. There were some comments I saw in there to address from @RaymondWise.
Application.Tranpose(Application.Tranpose(..))
. This is a cheap trick to convert a 2D array returned by .Value
into a 1D array that is a single row.UpdateScrollbars
that forces Excel to refresh the scroll bar boundaries. Sometimes they can get huge after deleting some values. They are updated when you save, but you can also just call UsedRange
and it causes Excel to refresh things. Another cheap trick.
This is the big item that needs to be done. This is inline with the changes made by @RaymondWise and should be applied to all the code files. Items that should be included: