On Wed, 17 May 2006 17:45:06 -0500, whitehurst
wrote:
Hello all,
Has anybody created a listing of possible alternative options for the
various GET.CELL functions? Ideally, since it gives the annoying
warning message at startup, I would prefer not to use the outdated
GET.CELL function.
I am specifically interested in determining if a given cell is
currently visible (height=0). I can do this with GET.CELL or with a
very simple VB Macro - I am just wondering if there is a way to
accomplish the task just through built-in excel functions.
Thanks!
Try this:
Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/
Then use the formula:
=XLM.GET.CELL(17,cell_ref)
--ron