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
- I dont know why my functions do not work and i get #VALUE!
3 Replies
Sort By
- PeterBartholomew1Silver 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.
- RTCopper Contributoranyone willing to help im still stuck loooool
- RTCopper ContributorI dont know why my functions do not work and i get #VALUE!