View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LesHurley LesHurley is offline
external usenet poster
 
Posts: 61
Default calling VBA from EXCEL

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?

--
Thanks for your help