Hi Hawki,

A UDF typically gets reevaluated only when its input parameters (in this
case, A1) or one of their precedents change. If you want to force a recalc
on every worksheet change, you can put Application.Volatile as the first
statement in your UDF.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Hawki wrote:
I have created a function that returns a range. The
function is called getRange(intColumn as Integer). I use
it in in a worksheet function as follows in cell A1:

=count(getRange(2))

It works when I type in the function, but when I make
changes on the worksheet, cell A1 is NOT updated
accordingly. It appears as if the cell is NOT re-
evaluating the getRange(2) when the worksheet is updated.
Any help would be appreciated. TIA...