Hi
I am a vba self taught hack, and nota very good one at that, and i need some help with variable length arrays. Below is the code I have which works perfectly but does not use arrays.
I have 4 columns. In Column A is a list of names. There are always atleast 2 or more of the same name and the same names are grouped together one under each other.
Then in Column B is a list of numbers representing qty of an item sold by that person. Then in column C is the time in number of days that it took that person to sell that qty.
Nowhere in the VBA code do i refer to column C, but Columd D is Column C multiplied by 5.
This function allows me enter a persons name and a random number of days that does not neccessarily correspond to any exact number of days related to that persons sales up to that period allowing for interpolation and extrapoltion, spewing out an interpolated or extrapolated number
Below is the code I have which works perfectly.
This function above calls on the following Interpolation extrapolation function.
The above two functions work perfectly, however CalcRange (Column D) is a function of column C multiplied by 5 and what I want to dois create an array of numbers called CalcRange in VBA and use that array when my function calls on the Interpolation function ..QtySold = PLI(TimeRange, CalcRange, Days, nn) and not have to calculate it seperately in excel like i have done in Columd D.
Below attempt is a disgrace i know...but if anyone can help me it would be much appreciated
I hope i have explaind my request. If it is not understood it is no doubt my bad explanation.
Thanks to all those people in adavnce who look to help me.
Bookmarks