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
|