realjumpy7
04-22-2013, 05:17 AM
Hello everyone, I just got interested in VBA and I seek help from veterans :)
In fact I have a set of data collected for some weeks. Except that there's weeks where there is no data.
I used a VBA function that interpolates the data. Except that the Xarray and Yarray used in this function must not contain null values.
function is defined as follows: PINTERP (Xrange, yrange, celulle)
An illustrative Excel file is attached with the VBA code ...
Can you help me on this?
Thank you in advance
In fact I have a set of data collected for some weeks. Except that there's weeks where there is no data.
I used a VBA function that interpolates the data. Except that the Xarray and Yarray used in this function must not contain null values.
function is defined as follows: PINTERP (Xrange, yrange, celulle)
An illustrative Excel file is attached with the VBA code ...
Can you help me on this?
Thank you in advance