Code for Average in VBA

**Ganee** · July 28th, 2009, 02:34 AM

Hi,

Can someone please help with a single VBA syntax to calculate the average of some generated numbers?

Thank you.

**DataMiser** · July 28th, 2009, 03:07 AM

Its fairly simple just create a var to hold your total.
Add all the numbers together
Divide by the number of numbers used.

Code:

T=x+y+z
A=T/3

**makdu** · July 28th, 2009, 04:12 AM

Save the numbers generated to different variables. Then add all the values together and then divide it by the number of variables used. That will give you the solution .

**dglienna** · July 28th, 2009, 10:08 PM

Look up:

Code:

Eval()

Thread: Code for Average in VBA

Thread Tools

Display

Code for Average in VBA

Re: Code for Average in VBA

Re: Code for Average in VBA

Re: Code for Average in VBA

Posting Permissions