|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
When you use cell.formula in VBA code, it returns an error when the formula is really long. This happens when the formula has many references to cells in another workbook and the referenced workbook is closed. Because the referenced workbook is closed, all the cell addresses have the full path added to the address. This means that the formula is now very very long and cannot be referred to with the .formula property.
Is there a way around this, other than opening the referenced workbook?
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
