Microsoft Office Tutorials and References
In Depth Information
Using CELL to Track the Last Cell Changed
Using
Using CELL
CELL to Track the Last Cell Changed
to Track the Last Cell Changed
If you leave off the second argument of the CELL function, Excel returns the
information about the last cell changed in the workbook.
Follow these steps to create an interesting watch window of the last cells
changed:
11. In an out-of-the-way spot, enter the formula =CELL(
=CELL("address"
"address").
22. Just below this formula, enter the formula =CELL(
"Contents").
33. Just below that formula, enter the formula =CELL(
=CELL("Contents"
=CELL("filename"
"filename").
44. Select all three of these cells.
55. From the Formulas tab, select the Watch Window icon. The Watch Win-
dow dialog appears.
66. Click the Add Watch button in the Watch Window dialog.
77. Because initially, the default file widths are not wide enough to show
the complete value, drag the vertical bars between the headings in the
Watch Window so that you can see the complete Value and Formula
columns. The other columns for Book, Sheet, and Cell can be made
smaller.
The result, as shown in Figure 12.19 , is a floating window that always re-
veals the last changed cell address and contents.
Search JabSto ::




Custom Search