How can I get WorksheetFunction.Growth to work properly?

I'm having a lot of syntax issues with this is my code

Range(Cells(2, 4), Cells(911, 4)) = Application.WorksheetFunction.Growth(Range(Cells(2, 3), Cells(85, 3)), Range(Cells(2, 1), Cells(85, 1)), Range(Cells(2,1),Cells(911,1)))

'Cells(2, 4).AutoFill Destination:=Range(Cells(2, 4), Cells(911, 4))

I would like to keep everything in the Range(Cells(),Cells()) format

C2:C85 are the [known Ys].

I want to take the growth of that and put the result in D2:D911 [to be calculated Ys].

A2:A911 (where A2 = 1 and counts all the way down to A910 = 911) are the [known Xs]

And I want it to also use the A2:A911 range again for the [new Xs]

I have both lines of code there since I am not sure whether or not I should be including my whole range during the growth execution....or if i should execute onto on cell, then auto fill the rest of the array (since the growth function is an array, correct?). How can I get WorksheetFunction.Growth to work properly?

-------------Problems Reply------------

The first part should be sufficient:

Range(Cells(2, 4), Cells(911, 4)).Value = _
Application.WorksheetFunction.Growth _
(Range(Cells(2, 3), Cells(85, 3)), _
Range(Cells(2, 1), Cells(85, 1)), _
Range(Cells(2, 1), Cells(911, 1)))

Category:Office Views:1 Time:2013-06-12

Related post

  • Deadlocks on Drop procedure statements 2011-04-28

    I have been working on improving the installation speed of our database (with thousands of objects) by multi threading the creation of the objects. This has caused the unfortunate behavior of causing deadlocks on the DROP PROCEDURE statements. Single

  • Organic growth with Lindenmayer Systems 2008-09-19

    I'm looking for a good way to represent organic growth - especially trees and flowers - using code. I've found Lindenmayer Systems as a reasonable way to portray this, but need a good place to start programming this. Any good suggestions? -----------

  • Simple WPF sample causes uncontrolled memory growth 2008-10-10

    I have boiled down an issue I'm seeing in one of my applications to an incredibly simple reproduction sample. I need to know if there's something amiss or something I'm missing. Anyway, below is the code. The behavior is that the code runs and steadi

  • SQL Server 2005 auto growth by size 2008-10-14

    I have been looking at the new database server we are setting up for a client and note the database files are set to grow by 1 meg everytime the file is full and the initial size is 100 MB. I have been considering this breifly and it doesn't sound ri

  • How to change the Auto Growth size? MS SQL Server 2005 2009-01-23

    In MS Sql server 2005, by default 1MB Auto Growth is there, How can i change it to whatever i need.? Thanx, Ambanna --------------Solutions------------- In SQL Server Management Studio, right click on the database. Go to Properties. Then go to the Fi

  • Predicting Oracle Table Growth 2009-01-30

    How can I predict the future size / growth of an Oracle table? Assuming: linear growth of the number of rows known columns of basic datatypes (char, number, and date) ignore the variability of varchar2 basic understanding of the space required to sto

  • Software Bandwidth/Database Growth Formulas 2009-03-02

    Are there any industry standard formulas or rules of thumb for determining: Application bandwidth usage/requirements Database growth requirements I have recently started managing a new .NET 3.5/SQL Server project and would like to take a more structu

  • What is the direction of stack growth in most modern systems? 2009-03-20

    I am preparing some training materials in C and I want my examples to fit the typical stack model. What direction does a C stack grow in Linux, Windows, Mac OSX (PPC and x86), Solaris, and most recent Unixes? --------------Solutions------------- Stac

  • Can i configure a ARM processor for Ascending Stack growth direction? 2009-05-25

    There has been one question here which talked about stack growth direction. To which Michael Burr had replied saying in ARM processors stack growth direction can be configured - i.e. either descending (normal behaviour) stack grows towards zero addre

Copyright (C), All Rights Reserved.

processed in 0.129 (s). 11 q(s)