I missed where you said you tried application.Volatile as the first line of
the function. I know you discussed this with Jerry Lewis, so I don't know
if that is something you have tried or not. You can do a full recalc with
Ctrl+Alt+F9
Another problem is that the function may result in an error if it isn't in
the active cell - However, I would think you would get a #Value result in
that case although I can't say for sure.
--
Regards,
Tom Ogilvy
"Mac Lingo" wrote in message
hlink.net...
I have the following call to a VB Subroutine in my code:
=Gen_Note(A7)
The only way I can get it to execute is to that I move my cursor to the
particlar cell, hit the left mouse key
twice, and hit return to calculate.
I've tried copying the call into another line; that doesn't force it to
make
a call. <F9 doesn't get it to calculate either.
What can I do?
Thanks for your help,
Mac