Printing matrix to worksheet

[codebreaker3]

Hello everyone,

I've been trying to learn VBA for just over a week now, and I need some help with a class assignment. The assignment asks to manually add 2 matrices together and to print the result onto a worksheet.

I have made a function to add the 2 matrices, and a subroutine to input the matrices and print the result onto a worksheet. From my novice POV I can't find anything wrong with what I've done except that the function or subroutine doesn't work.

I would be very grateful if someone could check my code and tell me what's wrong with it. Also, I would love to receive feedback about what I've done so far - is the code written clearly? is it unnecessarily complicated? etc. Thanks to everyone in advance.

assignment012-arrayADD.xlsm

[mehmetcik]

I have cleared most of your errors.

your code is quite clear so congrats on that.

You forgot to write the code to add the matrices together.

If you are in explicit mode all your variables must be defined

You cannot define and set a variable in one line

Your sheetnames must be in quotation marks unless they are held in variables.

Please Login or Register  to view this content.

[AlphaFrog]

The not-so-obvious issue that's holding you up is VBA doesn't like a code module and function to be named the same. So change either the code module name or the function name so they are different.

There are other issues with the code which I'll let you work out. One basic one is you haven't passed the result to the Function name. At some point in your code you'll need...
addmatrix = the calculated results

[codebreaker3]

Thanks very much for the corrections. I thought the function addMatrix should suffice? :

Please Login or Register  to view this content.

[codebreaker3]

Thanks for the reply. I've added to code you said, but whenever I try to test only the function the answer I get is 0. What sort of issues are there with the function code? Is there anything wrong with the procedure? or is the problem with the syntax?

[mehmetcik]

Look at this page.

http://stackoverflow.com/questions/2...-to-add-arrays

There is a neat solution that uses paste special to sum two arrays, but that is not a manual solution and is no good to you

It also shows a second solution using two nested loops to sum the arrays.

Two more things your code does not address is what happens if the user presses cancel or aborts an input box.

Also what happens if the arrays specified by the user are not the same size.