Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Public Function Remarks TKS_Mark Excel Discussion (Misc queries) 2 September 23rd 08 07:12 PM
Public Function Question Carl Excel Worksheet Functions 7 August 31st 06 08:15 PM
Using A Public Function / carl Excel Worksheet Functions 1 April 6th 06 09:13 PM
public function tom mcdonald[_4_] Excel Programming 2 October 10th 05 01:51 PM
Public Function Monty Excel Discussion (Misc queries) 9 December 24th 04 06:35 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"