+ Reply to Thread
Results 1 to 7 of 7

[Urgent/Simple] I have a defined function and a defined range of cells. How do I do =MyFun

  1. 03-29-2016, 05:02 PM #1
    excelfriend1
    excelfriend1 is offline
    Registered User
    Join Date
    01-11-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    19

    [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =MyFun

    Here is what I have:

    Please Login or Register  to view this content.
    I want to use =MyFunct for that rng. How do I do that?

    Something like... =MyFunct(rng) ... but it won't work.
    Reply With QuoteRegister To Reply
  2. 03-29-2016, 05:14 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Perhaps.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 03-29-2016, 05:30 PM #3
    excelfriend1
    excelfriend1 is offline
    Registered User
    Join Date
    01-11-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    19

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Quote Originally Posted by Norie View Post
    Perhaps.
    Please Login or Register  to view this content.
    Says there is a syntax error on the last line. Any idea?
    Reply With QuoteRegister To Reply
  4. 03-29-2016, 05:47 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Oops, slight typo.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-29-2016, 05:50 PM #5
    excelfriend1
    excelfriend1 is offline
    Registered User
    Join Date
    01-11-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    19

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Woohoo, that did it! Last simple question. How do I remove the last chr(10) from the concatenated cell? I only ask because my function looks like this:

    Please Login or Register  to view this content.
    It seems to add an extra chr(10) or two after the function concatantes the range.
    Last edited by excelfriend1; 03-29-2016 at 05:54 PM.
    Reply With QuoteRegister To Reply
  6. 03-29-2016, 06:06 PM #6
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,344

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Not sure exactly what you want but try one of these

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-29-2016, 07:45 PM #7
    excelfriend1
    excelfriend1 is offline
    Registered User
    Join Date
    01-11-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    19

    Re: [Urgent/Simple] I have a defined function and a defined range of cells. How do I do =M

    Quote Originally Posted by scottiex View Post
    Not sure exactly what you want but try one of these

    Please Login or Register  to view this content.
    SECOND ONE DID IT. Love you. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If word entered not in defined name range, copy & paste it to bottom of defined name range
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2014, 01:08 PM
  2. [SOLVED] Error 1004: Application-defined or object-defined error on Range(Cells(x,y)) syntax
    By winch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2013, 11:02 AM
  3. [SOLVED] Run Time 1004 - App Defined or Object defined error with String defined path structure
    By sarails in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2012, 09:38 PM
  4. Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2006, 08:20 PM
  5. Application-Defined or Object-Defined Error on simple code
    By Fid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2005, 04:05 PM
  6. [SOLVED] User-Defined Function to Determine Content of Cells in a Range
    By RBohannon in forum Excel General
    Replies: 2
    Last Post: 06-02-2005, 12:05 PM
  7. [SOLVED] Application-Defined or Object-Defined Error on simple code
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1