Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two matrices | Excel Discussion (Misc queries) | |||
Can Excel solve matrices? | Excel Discussion (Misc queries) | |||
matrices | Excel Discussion (Misc queries) | |||
How do I multiply matrices in Excel? | Excel Discussion (Misc queries) | |||
transpose matrices | Excel Programming |