worksheetfunction.average

[Sc0tt1e]

Why is this producing 0 when the result should be a decimal point answer (0.032748161) which is what I want?

I have tried formatting and rounddown but neither work.

Please Login or Register  to view this content.

[protonLeah]

Because you have Dim'd APave as Long, i.e., as an integer value (whole number). Therefore use
Dim APave As Single or
Dim APave As Double (depending on how many decimal places you want)

[Sc0tt1e]

I'm just making stupid mistake after stupid mistake tonight, Cheers Proton you're a Legend