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

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

Matrices in VBA / Excel
 

Dave Peterson wrote:
You have a suggestion at your post in .excel.

Thanks :) (i had deleted my post in ms.public.excel thinking that this
newsgroup was better suited ... but i'll continue the thread there too)

--
Antoine Cellerier
dionoea