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)

C = Array(1, 2, 4, 8, 12, 16, 20, 24, 28, 32, 36, 40, 44, 48, 50)
T = Array(0, 15, 20, 40, 60, 80, 100)
rho_0 = Array(1.0124, 1.0244, 1.0482, 1.0943, 1.1399, 1.1849, 1.2296, 1.2741, 1.3182, 1.3614, 1.403, 1.4435, 1.4825, 1.521, 1.54)
rho_15 = Array(1.01065, 1.02198, 1.04441, 1.08887, 1.13327, 1.17761, 1.22183, 1.26582, 1.3094, 1.352, 1.3933, 1.4334, 1.472, 1.5102, 1.529)
rho_20 = Array(1.0095, 1.0207, 1.0428, 1.0869, 1.1309, 1.1751, 1.2191, 1.2629, 1.3064, 1.349, 1.39, 1.43, 1.4685, 1.5065, 1.5253)
rho_40 = Array(1.0033, 1.0139, 1.0352, 1.078, 1.121, 1.1645, 1.2079, 1.2512, 1.2942, 1.3362, 1.3768, 1.4164, 1.4545, 1.4922, 1.5109)
rho_60 = Array(0.9941, 1.0045, 1.0254, 1.0676, 1.1101, 1.1531, 1.196, 1.2388, 1.2814, 1.3232, 1.3634, 1.4027, 1.4405, 1.4781, 1.4967)
rho_80 = Array(0.9824, 0.9929, 1.0139, 1.056, 1.0983, 1.1408, 1.1833, 1.2259, 1.2682, 1.3097, 1.3498, 1.3889, 1.4266, 1.4641, 1.4827)
rho_100 = Array(0.9693, 0.9797, 1.0009, 1.0432, 1.0855, 1.1277, 1.17, 1.2124, 1.2546, 1.296, 1.336, 1.375, 1.4127, 1.4503, 1.469)
A_rho = Array(rho_0, rho_15, rho_20, rho_40, rho_60, rho_80, rho_100)

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

  interpolated=(TT,cc) interp2(T,C,A_rho,TT,cc);
  rho_F = interpolated(T2,C2)

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!