calling VBA from EXCEL

[LesHurley]

I have a VBA procedure Aug that augments one matrix with another as in Aug(M,b)
M b

1 2 3 2 1
3 2 1 3 4
4 1 0 4 1

A

1 2 3 2 1
3 2 1 3 4
4 1 0 4 1

Then I can call another of my VBA procedures, Canform(A) which calculates
the canonical form of A as in

C

1 0 0 1.125 -0.875
0 1 0 -0.5 4.5
0 0 1 0.625 -2.375

This also works fine.
I think I should call them serialy as =canform(aug(M,b)) and get the same
result. What I get is an error message that says "A value used in the
formula is of the wrong data type.

What's wrong with this?

 

[Leith Ross]

I have a VBA procedure Aug that augments one matrix with another as in Aug(M,b)
M b

1 2 3 2 1
3 2 1 3 4
4 1 0 4 1

A

1 2 3 2 1
3 2 1 3 4
4 1 0 4 1

Then I can call another of my VBA procedures, Canform(A) which calculates
the canonical form of A as in

C

1 0 0 1.125 -0.875
0 1 0 -0.5 4.5
0 0 1 0.625 -2.375

This also works fine.
I think I should call them serialy as =canform(aug(M,b)) and get the same
result. What I get is an error message that says "A value used in the
formula is of the wrong data type.

What's wrong with this?

Hello LesHurley,

You need to show the VBA code for both procedures: Aug(M,b) and
Canform(), before anyone can answer your question.

Sincerely,
Leith Ross

 

[LesHurley]

Thanks for the reply, Leith. I wouldn't mind sending the code but that's
quite a bit of code to display in the small window we have available.
Canform() itself has about 75 lines, and it calls two other function
procedures, all together about 150 lines of code. Aug() is smaller, about 35
lines. I think I will write two much simpler test routines and see if I can
successfully do the same thing with them. If not, the group will here from
me again.
Thanks for your help