Forum Discussion

RT's avatar
RT
Copper Contributor
Jun 28, 2021
Solved

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

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

  • RT's avatar
    RT
    Copper Contributor
    anyone willing to help im still stuck loooool
  • RT's avatar
    RT
    Copper Contributor
    I dont know why my functions do not work and i get #VALUE!

Resources