Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » CELL Worksheet Function

CELL Worksheet Function

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. [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2011/08/09/cell-worksheet-function/

Posted Aug 09 2011, 10:06 AM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.