Averaging

  • Thread starter Thread starter stephentebaldi
  • Start date Start date
S

stephentebaldi

does vba not recognize the same functions as excel? I checked the vba
help files and it says it will do averaging. If I select a range of
data and then try to average it, it says that the function is not
defined. Can I not average a predefined range. My code below probably
explains it more easily.

Dim Standards As Range
Set Standards = Application.InputBox("Please Select Data for
Positive Standards", Type:=8)
Dim Blanks As Range
Set Blanks = Application.InputBox("Please Select Data for
Blanks", Type:=8)

AveStds = Average(Standards)
AveBlks = Average(Blanks)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conflict of one loop to another? 3
Insert text in column A and calculate the average from column B 4
Taking an average of ranges 1
I'm getting unwanted rounding to integer for an average of range of cells. 2
Some more help with code...Averaging a range 1
Similar Book to Book Code, one works other does not 11
calculating weighted average cost of capital in a macro 2
why does Average only on certain cells? 4

Back
Top