I cannot install the macro as it says it is blocked for security reason. I read the Peltier article and it showed going to the properties of the xlam file and unblocking. However, when i rt. click the file and go to properties, my properties dialog does not look at all like the one shown. It has only one tab, "General" (not Security, Details, and Previous versions). And the "General tab" does not have the verbiage to unblock as shown in the article. Any suggestions as to how to unblock and install?
In the first version, named ranges were certainly an issue. However, I made a really radical change to make it work in v1.2.5. It is supposed to apply all named ranges used in formulas (formulas in the selected range). I am going to send you a private message, that would be really great if you could share a sample workbook with me that you are having trouble with this.
Thank you!