View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Matrix Ops Type Mismatch

Typo

or if you prefer the fefault 0 base
Dim myArray(x - 1, 1 to x - 1)


or if you prefer the default 0 base
Dim myArray(x - 1, x - 1)

where x is the count of required elements, which must be the same for both
rows & cols with MINVERSE

Peter T


Try putting, at the top of your module -
Option Base 1

or declare your arrays like this

Dim myArray(1 to x, 1 to x)

or if you prefer the fefault 0 base
Dim myArray(x - 1, 1 to x - 1)

Regards,
Peter T