View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Public function in Personal.xls

I think you should try application.run using a function.

I bet it works.



Ardus Petus wrote:

Application.Run is OK for a Sub, not a Function.

Setting a reference to Personal.xls fails: "Module name, project name or
library name already in use"

Cheers
--
AP

"Bob Phillips" a écrit dans le message de news:
...
Look at Application.Run in help, or set a reference to Personal.xls in
your
workbook, then you could call them as if they were locakl to your
workbook.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ardus Petus" wrote in message
...
I have a series of utility functions in Personal.xls

I know how to call them from a worksheet cell.

What is the syntax to call them from VBA code?

TIA,
--
AP





--

Dave Peterson