SOLVED

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)
Solution
I dont know why my functions do not work and i get #VALUE!
anyone willing to help im still stuck loooool

@RT 

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.