Forum Discussion
RT
Jun 28, 2021Copper Contributor
NEED help with VBA
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
- Jun 28, 2021I dont know why my functions do not work and i get #VALUE!
PeterBartholomew1
Jun 28, 2021Silver Contributor
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.