Tim has attended:
Excel VBA Intermediate course
Excel equation into VBA
Trying to create a VBA function to replicate the excel function =SQRT(SUMSQ(A:A)) Where A:A is any selected range of numbers
current Function code is below:
Function QSUM(myRange As Range, Critiria As Double)
QSUM = Sqr(Application.WorksheetFunction.SumSq(myRange))
End Function
At present value error returned.
RE: Excel equation into VBA
Hi Tim,
Thank you for the forum question and the nice feedback.
I think I must have confused you with the Countif example and I didn't see it when I looked at it during the course.
Try:
Function QSUM(myRange As Range)
QSUM = Sqr(Application.WorksheetFunction.SumSq(myRange))
End Function
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
