| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multplying matrix with constant doesn't work in VBA
I have a matrix like this...
12 4 22 2 1 33 54 2 9 ....and the following function... Function myfunc(m) myfunc = 2 * m 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
| Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
| Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
| Improrting Text file to a matrix when things are not constant. | Excel Worksheet Functions | |||
Threaded Mode
