View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antoine Cellerier Antoine Cellerier is offline
external usenet poster
 
Posts: 4
Default Matrices in VBA / Excel

Hello,

I have something like:

Dim a As Range
Set a = (some range containing only doubles)

Dim b As Range
Set b = (some range the same size than a's)

b.value = a + a

When watching "a+a" i get a <Type mismatch error. It works fine with
WorksheetFunctions like MInverse or MMult. I can't get the addition to work.

Any help would be greatly appreciated.

Many thanks,

--
Antoine Cellerier
dionoea