Results 1 to 4 of 4

Thread: Create Custom Function

  1. #1

    Create Custom Function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    can we make our own or you may say i.e, custom function.

    suppose a formula i.e, =sum(A1:F1) and we define the name for the formula "xyz".

    My question is if we put the formula "xyz" in any workbook of different Excel file, than it calculates sum of the above range either absolute or relative reference.

    summery of question : How to record of custom formula

  2. #2
    You would need to put the UDF in an addin.

  3. #3
    Thanks for suggestion. But sir, I can not find in Excel Option---->Add-Ins--->Manage Excel Add-ins. I request you, please suggest how to install.

  4. #4
    You need to create a new workbook, add the UDF, save it as an addin, then get your people to install it http://office.microsoft.com/en-gb/ex...010342658.aspx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •