Hints - Microsoft Excel - Leaving Trace Precedents Turned On

Microsoft Excel - Leaving Trace Precedents Turned On

The macro determines which cells in the worksheet contain formulas (only formula-containing cells can have precedents) and then steps through each of those cells, turning on the display of the precedents.

The problem, of course, is that this approach doesn't do exactly what Clair wanted. It is probable that Clair, when working with her data, doesn't turn on the precedents for every single cell, but only for some of the cells. The macro turns on precedent display for all possible cells in the worksheet. 

If you only want to display the precedents for some cells, you need to specify the cells in the macro.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London