+ Reply to Thread
Results 1 to 3 of 3

User defined function to output multiple values

  1. #1
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137

    User defined function to output multiple values

    Hi,

    Thanks in advance for any help.

    I have a function which currently is defined like this:
    Please Login or Register  to view this content.
    It nicely returns the date I want. But I actually want to return another date into the adjacent cell as a value. How do i do this?

    Regards

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: User defined function to output multiple values

    Your function can only return a value to the cell(s) it is in, so you would have to have it return an array and array enter it into both cells at once.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137

    Re: User defined function to output multiple values

    Thanks, wasn't too difficult in the end. it went something like:

    Please Login or Register  to view this content.
    Remembering when in worksheet to enter the formula, then select the cell plus four cells to the right, hitting f2 then control>shift>enter

+ 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