What is going wrong here...

  • Thread starter Thread starter a321654987
  • Start date Start date
A

a321654987

I have a matrix like this...

12 4 22
2 1 33
54 2 9

....and the following function...

Function myfunc(m)

myfunc = 2 * c

End Function

Passing on the matrix to exactly this funciton (letter by letter) in
Excel 2003 SP2 results in #VALUE!

Why? What is wrong here? My guess is that some data type definitions
are missing. Can somebody help?
 
Where is the matrix defined? On a sheet or in a VBA array? What is 'c'? What
leads you to believe you can multiply a matrix by a scalar in VBA? How are
you calling the function?



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Back
Top