+ Reply to Thread
Results 1 to 2 of 2

Cannot Call UDF written in Module1

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Cottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Cannot Call UDF written in Module1

    Good Morning,
    I am looking for a function which creates a unique list from a number of ranges and have found this one here:

    http://www.atlaspm.com/toms-tutorial...ltiple-ranges/

    I have pasted the code into "Module 1" but cannot call it - i get the #NAME error. What am I missing here?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Cannot Call UDF written in Module1

    do you have macros enabled and is the code in the same workbook as the cell you are trying to call it from?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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