Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ernesta Fernandez   on Nov 18 In MS Office Category.

  
Question Answered By: Brent Brown   on Nov 18

Also I ran into 'Unable to get the MMult property..' which I suspect
is solvable by
Application.WorksheetFunction.Transpose(Extrate)
instead of
Extrate
in the bothersome line.

because MMULT requires that 'the number of columns in array1 must be
the same as the number of rows in array2', and I *think* that vba
sees array2 as a single row horizontal array.

THEN I get the type mismatch again...

Running out of time now, one shot in the dark though; does this need
to be a loop? Would
results() = Application.Worksh....
work rather than
results(k) = Application.Worksh...
?

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on About array matrix function Or get search suggestion and latest updates.


Tagged: