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!