+ Reply to Thread
Results 1 to 2 of 2

Functions in array formulas

  1. #1
    Registered User
    Join Date
    02-10-2011
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    Functions in array formulas

    Hi all. I have a strange question, in the sense that I myself don't know exactly what I have to ask; so please be patient. The general subject is Array formulas (which btw I have just begun using).
    ---
    I put this in the cell G5:
    =D5:D7*E5:E7
    then I select the cells G5:G7, press F2, then shift+ctrl+enter and I get the array formula.
    {=D5:D7*E5:E7}
    ---
    I'd like to know if it's possible (and how) to use a function of mine instead of a built-in function like *. Maybe it's a silly question, but I wasn't able to understand it by my own. For instance, I tried to write a function which performs the same task of the formula above:
    Please Login or Register  to view this content.
    When I build the array formula, all the cells G5:G7 show the result of the cell G5. I don't know how to determine the address of each cell of the array and to return the corresponding result. If I change that function (just in the attempt to understand something) in
    Please Login or Register  to view this content.
    the function returns the same total range in each row.
    $G$5:$G$7
    $G$5:$G$7
    $G$5:$G$7


    Does my question make sense?
    Antonio

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Functions in array formulas

    Antonio, have a look at Chip Pearson's page on the topic: http://www.cpearson.com/excel/Return...ysFromVBA.aspx

+ 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