Interpolation of 2D Array

Hello there!

I am trying to figure out how to interpolate a 2D data array using VBA with the data being kept within of a macro.

Below, the T (y) and C (x) is chosen by the user (two cells with the information) and the A_rho is the combined rho variables.

VBA Data (dataset can be changed if needed, this is just how I set it up)

Please Login or Register  to view this content.

I am able to do this with Matlab, but not with a VBA function.

Matlab code with an internal interp2 file looks something like this

Please Login or Register  to view this content.

Note: at sign after interpolated= is removed due to forum thinking it is a link.

Example:
A1 = T2 = 20
A2 = C2 = 42
A3 = output = 1.4492

I can figure the interpolation out if the data is in the excel already, but when the data is inside the code, I am very unsure. Any suggestions would be great.

Cheers!

Maybe :

Please Login or Register  to view this content.

Formula on A3 :

Please Login or Register  to view this content.

If you need to change the data, just edit the hardcoded data in sub SetData() and then run this sub.

You are welcome svensvba, thanks for marking the thread as solved and rep.points.

Regards