Hi,
I am trying to use the LinEst function in a program. There are some good examples on the web but they all refer to a range in the format “A1:A45”. Is there a way to refer to a column in an existing array instead?
For example (thanks to Shg for this code):
Instead of:
Could I havePlease Login or Register to view this content.
Where Array1 holds some data of interest.Please Login or Register to view this content.
Hope this makes sense.
Bookmarks