View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Matrices in VBA / Excel

You have a suggestion at your post in .excel.

Antoine Cellerier wrote:

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


--

Dave Peterson