View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I get this VB Call to work?

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