I learned something today. I “knew” that omitting the optional reference argument from the CELL worksheet function meant that the cell that contained the worksheet function was used. Patrick McDonald correctly pointed out that it uses the last changed cell, not the host cell.
In a new worksheet, type
=CELL("width") in cell B3. If you’re using Excel 2003 like me, you’ll probably get 8 as the answer. Now increase the width of column D and type a ‘1’ in D3. Cell B3 will report the width of D3 because it’s the last cell changed.
I like learning things. I don’t like learning things that I should have already known. Hopefully this is the last one and that now I know everything.