Hi
one way:
use the column as range parameter in your function

or add the line
application.volatile at the beginning of your function

Note: As you don't use a cell/range reference in your function as
parameter Excel does not know if it should re-calculate the function if
something in column 2 changes.


--
Regards
Frank Kabel
Frankfurt, Germany


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...