On Fri, 19 May 2006 21:59:41 -0400, Ron Rosenfeld
wrote:

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

Sorry, I did not see you wanted to do that just with built-in functions. But I
believe Longre's XLM.GET.CELL function has some advantages over the "built-in"
GET.CELL function.
--ron