Quickly add your macros to buttons and drop down lists on Excel Ribbon macros tab. Get free workbook, make easy changes, so tab shows for all files
Change info on the worksheet, to update Ribbon custom tab to run your Excel macros
The VLOOKUP function is very powerful, but it will only return values that meet a very limited set of criteria. If you want to adjust what the function returns, you may be out of luck unless you apply the techniques described in this tip.
Name Manager has just been updated to build 664. Name Manager will no longer mark names using the new Dynamic Array references as names with errors.
RefTreeAnalyser 2.0 has just been updated. It now works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references.