Results 1 to 5 of 5

Using a worksheet function within a user defined function

Threaded View

Atom Using a worksheet function... 08-27-2016, 07:51 PM
TMS Re: Using a worksheet... 08-27-2016, 07:55 PM
Atom Re: Using a worksheet... 08-28-2016, 08:00 AM
TMS Re: Using a worksheet... 08-28-2016, 11:26 AM
Atom Re: Using a worksheet... 08-31-2016, 09:56 PM
  1. #1
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Using a worksheet function within a user defined function

    How does one use/call any of the common worksheet functions within a user defined function?

    I started on this because I wanted to convert this worksheet formula (which does case sensitive lookups) to a UDF.
    ={INDEX(Rng,MATCH(TRUE,EXACT(somevalue,Rng),0),1)}
    Last edited by Atom; 08-27-2016 at 08:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Usage of standard functions into custom function (or user defined function)
    By tusharb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2016, 12:43 AM
  2. User defined function, pulling data from another worksheet
    By topnotchthrillr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2015, 10:00 PM
  3. Creating a user defined function based on a complex worksheet formula
    By Atul Maskara in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2014, 09:36 AM
  4. [SOLVED] User defined function using information from active worksheet.
    By Matuna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-14-2012, 06:57 AM
  5. Passing multiple parameters in user defined function from worksheet
    By cmschu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2009, 02:39 AM
  6. [SOLVED] Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM
  7. [SOLVED] Error messages from user defined Excel worksheet function
    By Helge V. Larsen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2006, 12:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1