Posts by pou2010

Thank you royUK, sorry for the mistake, i'll read the rules and be careful next time!

[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:

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

Thank you so much for any help, it's greatly appreciated!