adjusting code to accept data in row format

Hi
I have a very nice bit of code that interpolates between point on graphs with a smoothed line. The code is called cubic spline and it is extremely useful for all types of applications, finance through to engineering.

However, the code has been set up to only take data in rows rather than columns and i need to use it to take data in row format. The code calls other functions in its workings but this is the high level code. Is there an obvious way to make it accept data in row format? XX, and YY are the variables for the ranges of data in column format. I attach a simple excel sheet demonstrating the problem with the full code.

Worthdownloading just for the code.

thanks
t

Please Login or Register  to view this content.