+ Reply to Thread
Results 1 to 2 of 2

UDF: Function Dialog adds @ which prevents spill

  1. #1
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    UDF: Function Dialog adds @ which prevents spill

    Hello

    I had a post here which solved my initial problem
    https://www.excelforum.com/excel-pro...ml#post5834541

    I can now select a range of cells in my UDF and it will spill down the result.

    So if I manually enter the formula "=MyUDF(A1:A13)" it spills down as expected.

    If I open the dialog and select A1:A13 in the field, only the first cell is populated and the spill does not occur.
    It seems that it puts an @ after the equals as the formula appears "=@MyUDF(A1:A13)".
    If I remove the @ it works.

    How can I tell the function dialog not to put the @ there?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,599

    Re: UDF: Function Dialog adds @ which prevents spill

    Attach the workbook here - nobody should have to cross reference other threads in order to be able to offer help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] TEXTSPLIT Function: Is It possible to spill an empty cell with zero?
    By JN831 in forum Excel Formulas & Functions
    Replies: 79
    Last Post: 08-18-2023, 04:45 AM
  2. To spill Filter function wrapped in SUM Function
    By Vivek2705 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2023, 02:46 AM
  3. LET function not producing a spill range
    By Coley356 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2021, 03:44 PM
  4. [SOLVED] #spill! error using Filter function
    By Svey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2021, 03:50 PM
  5. [SOLVED] Spill error for index aggregate function
    By whahnelt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2021, 08:38 AM
  6. Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  7. [SOLVED] Using the =IF function is ok on single cell but gives#SPILL on a range
    By Brian Mc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2020, 05:37 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