Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting output from the TREND function using VBA
The TREND function has the syntax TREND(known_y's,known_x's,new_x's,const).
In order to output the array of estimated y values on a spreadsheet, the Excel Help entry specifies that a range must be selected beginning with the cell in which the TREND function is entered and extending downward so that the number of cells in the range is equal to the number of estimated y values. The user is then instructed to press F2, and then press CTRL+SHIFT+ENTER, causing the estimated y values to populate the selected range. That method works fine for outputting the estimated y values on a spreadsheet, but how do I output the estimated y values as an array within a VBA subprogram? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trend Function | Excel Worksheet Functions | |||
constraints for the trend function | Excel Discussion (Misc queries) | |||
Help with TREND function | Excel Worksheet Functions | |||
Trend function question | Excel Discussion (Misc queries) | |||
Trend function in VB | Excel Programming |