SOLVED

NEED help with VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-2491299%22%20slang%3D%22en-US%22%3ENEED%20help%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491299%22%20slang%3D%22en-US%22%3E%3CP%3EPStdev%20and%20STOCKLOW%20STOCKHIGH%20functions%20are%20not%20working%20correcctly%20for%20me%20as%20they%20should%20i%20have%20attached%20the%20files%20also%20what%20am%20i%20doing%20wrong%20can%20someone%20please%20help%20as%20this%20is%20due%20midnight%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2491299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2491320%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20help%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491320%22%20slang%3D%22en-US%22%3EI%20dont%20know%20why%20my%20functions%20do%20not%20work%20and%20i%20get%20%23VALUE!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2491354%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20help%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2491354%22%20slang%3D%22en-US%22%3Eanyone%20willing%20to%20help%20im%20still%20stuck%20loooool%3C%2FLINGO-BODY%3E
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.