+ Reply to Thread
Results 1 to 2 of 2

Help with array/function

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Rome
    MS-Off Ver
    Excel 2011
    Posts
    1

    Help with array/function

    Hi everyone, in the code below I know that I'm wrong with the multiplication between arrays ( y = AR(1) * ARR(1) ) and in the empty part within the circle Do While-Loop; my goal of that cycle is to find the value of x that makes y=0

    Then I need that someone tell me how to make in the right way the multiplication between arrays and to find the cycle that make the code works.
    Thanks in advance !!

    p.s. = obviously I took under account just the first passage, then for that problem you should consider just AR(1) and ARR(1), ignoring other


    Please Login or Register  to view this content.
    Last edited by FDibbins; 01-08-2015 at 06:13 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Help with array/function

    Hi aregaf, welcome to the forum

    1st, please give your thread a titler that describes your problem, not what you think your answer will be.

    2nd Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I will add them for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  2. Array function only displays first value of array as output
    By q-tip in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 12:51 PM
  3. SEARCH function returns array if first argument is array--Huh?
    By 6StringJazzer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2012, 07:23 PM
  4. Using the ReDim array function in a multidimensional array in excel
    By Doruli in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2012, 01:43 PM
  5. Read Range To Array, Then Pass Array To Function
    By ProbablyNotARealName in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2010, 12:29 PM

Tags for this Thread

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