NEED help with VBA

New Contributor

PStdev and STOCKLOW STOCKHIGH functions are not working correcctly for me as they should i have attached the files also what am i doing wrong can someone please help as this is due midnight 


3 Replies
best response confirmed by RT (New Contributor)
I dont know why my functions do not work and i get #VALUE!
anyone willing to help im still stuck loooool


The UDFs didn't work because the arguments on the worksheet do not match the parameters declared in the code.  Why do you want to use VBA anyway.   I have included modified VBA and worksheet formulas.  To my mind, worksheet formulas are better, especially if you can use LET or even LAMBDA.