< Back to screenshot
This tool will generate a map of the current sheet, showing cells that contain text, numeric values and formulas. It is is particularly useful to find cells that cause errors because Excel is seeing text rather than a number. A macro is inserted into the map sheet that makes every cell in the map a hyperlink to the original sheet.
If you don't want the macro in your workbook, either go to the visual basic
editor and delete the code, or delete the map sheet (the code is attached to the
map sheet rather than the workbook). The routine relies partly on
code from John Walkenbach's site.