MarkusAndersson
i dont know if it is what you are looking for but see attachment
http://files.engineering.com/getfile.aspx?folder=04f4a368-6b28-4322-94a2-49737be5686e&file=Image_click.xls
IDS thanks!
This vba function is work perfectly! and works something like MMULT() in spite of unequal number of rows and columns needed to multiply the matrix. :)
Only this function gives quite different outcome than the original function. :(
(Please see excel attachment with both tables and...
help
i have x and y array's i want to multiply. somthing like MMULT(Array1;Array2) but this time using vba function called planck()
-------------------------------------------------
Public Function Planck(Lambda As Double, Temperature As Double) As Double
Dim C1 As Double, C2 As Double, Eee...