| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multplying matrix with constant doesn't work in VBA
You'll just have to loop through the rows and columns to multiply each
matrix element individually. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ps.com... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multplying matrix with constant doesn't work in VBA
You'll just have to loop through the rows and columns to multiply each
matrix element individually. I did a function which is exactly doing that. The thing I don't understand why this is possible in a spreadsheet. For example, naming the above mentioned matrix "aMatrix", the following formula would product the correct result: {= 2*aMatrix}. Weird stuff, in my opinion. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multplying matrix with constant doesn't work in VBA
The worksheet is set up to treat worksheet ranges as a matrix in a similar
sense to our algebraic understanding of them. VBA doesn't know it's backing up a spreadsheet program. The only difference between VBA for Excel, Word, PowerPoint, and other applications is an object model that provides application-specific objects and their properties and methods. VBA can handle an array fine, although it makes you deal with the array elements individually. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... You'll just have to loop through the rows and columns to multiply each matrix element individually. I did a function which is exactly doing that. The thing I don't understand why this is possible in a spreadsheet. For example, naming the above mentioned matrix "aMatrix", the following formula would product the correct result: {= 2*aMatrix}. Weird stuff, in my opinion. |
| Reply |
| 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 | |||
Hybrid Mode
