[xpost][/xpost]
Hi everyone,
I'm new and very glad to be here. I've been having an issue with a super small part of my code, that goes like this:
I want to take an array of (n,1) and multiply it by m, then add a new row at the end of it with the number 3.
Everytime I want to run the code, I get an error telling me invalid qualifier, highlighting 'mat'.
Here is the code in text format if ever the picture doesn't work:
Code
Function myfct(vc As Range, m)
n = vc.Rows.Count
Dim mat()
Dim multip()
mat = Application.MMult(vc, m)
multip = mat.Resize(n + 1, 1)
multip(n + 1, 1) = 3
myfct = multip
End Function
Display More
Thank you so much for any help, it's greatly appreciated!