Matrix multiply/division

[DVDR]

Hello,
i would like to ask for help with the following VBA code. I need to write a funciton that multiplies or divides a matrix in Excel by a double value. I want to call the function like

Please Login or Register  to view this content.

where B2:C3 is an example of some selected area with double values. Of course, area of the same size is selected when the function is executed. I just keep getting #Value! error.

Please Login or Register  to view this content.

Thanks for any ideas,
David

[shg]

You don't need VBA for this. In some 2x2 range, array-enter =A1*B2:C3

[DVDR]

I know I don't need VBA for this example, this is just part of some other code i need to get working. The general question is how to get a Variant (Range) as a parametr, multiply or divide the values with double and return it back to cells in worksheet.

[snb]

Please Login or Register  to view this content.

[DVDR]

Please Login or Register  to view this content.

This code is nice, but would it be possible to have the number we multiply with as a double variable?

[snb]

Meaning ?

Please Login or Register  to view this content.

PS. in the worksheet you can enter
=matrixmultiply(A1:E5)
no need to use a matrix-formula

[DVDR]

Meaning ?

Please Login or Register  to view this content.

PS. in the worksheet you can enter
=matrixmultiply(A1:E5)
no need to use a matrix-formula

I meant that the double value is product of some other VBA code. For example i would like to count an average of the area and then divide every single value by this average.

[snb]

All at once:

Please Login or Register  to view this content.