use average in a userform
Hi Alvin,
Try:
TextBox1.Value = Application.Average(Range("A1:A10"))
---
Regards,
Norman
"alvin Kuiper" wrote in message
...
Sorry don't work
get a error in the line
alvin
"Rick Hansen" wrote:
Hi Alvin,
Try
TextBox1.value = WorksheetFunction.Average("A1:A10")
HTH
Rick
"alvin Kuiper" wrote in message
...
Hi
How to say
TextBox1.Value = Average("A1:A")
I know this is wrong so how?
thanks
Alvin
|