LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I use functions that I have written in Excel formulas

Are the functions in a general module in the workbook in which you are
calling them?

Should be OK in that case.

If stored in another workbook like Personal.xls you must preface the formula
as such................

=Personal.xls!myfunction(args)


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 10:22:03 -0800, Gita_B
wrote:

I have functions that I have written. i should have been able to use them in
EXcel formula but when i Use the function in the excel Sheet it is not
recognized. I get #Name Error.

Can some one help?

Regards
Gita.


 
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
How do I input these formulas into cells that I want written in? Paige Excel Worksheet Functions 4 December 31st 08 03:44 AM
Excel 2000 - Formulas and Functions DeeW Excel Discussion (Misc queries) 4 August 10th 06 07:00 PM
Help with Excel Formulas or Functions Containsmiles Excel Discussion (Misc queries) 7 May 23rd 06 11:59 PM
Hidden rows unhide themselves when formulas are written Hongch Excel Discussion (Misc queries) 3 January 19th 06 06:33 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 08:15 PM


All times are GMT +1. The time now is 05:42 AM.

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"