NEED help with VBA

[RT]

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 

[#2 · Accepted solution]

I dont know why my functions do not work and i get #VALUE!

[#3]

anyone willing to help im still stuck loooool

[#4]

@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.