All can be used, not all directly. For some you need to use =EVALUATE()


--
Gary''s Student - gsnu200770


"Sybmathics" wrote:

Don Guillett schreef:
Look in the VBA help index for FIND or record a macro while doing your
find to see how.

Don, thanks for the quick reply.

I had no trouble with the find function, though.
It works as expected.

I want to know why some worksheetfunctions can be addressed in VBA and
others can't.

The find function can be addressed even though it's not in the autolist.
Excel functions like date or value can not be addressed.

I don't see why.