About Average and Stdev code in VBA-waiting for your help online.

  • Thread starter Thread starter Together
  • Start date Start date
T

Together

Hi, everyone,

I try to write some code to calculate the average and standar
deviation for some range in excel. But I found my code can not work:

n = Sheets(1).Range("A11:K11").average
or

n=average(A11:K11) (the error shows I did not define the function)

I ever search the internet, but I found most of the users use the exce
formula to calculate the value. Can I write code to solve the problem
How to write it? Thank you
 
Hi
try
n = worksheetfunction.average(sheets(1).range("A11:K11"))
 
You must log in or register to reply here.

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

averaging non-contiguous data using arrays 1
Calculating Averages in VBA... 3
AVERAGE, STDEV, SEM with criteria 0
How to write STDev formula in a macro 3
Insert text in column A and calculate the average from column B 4
Calculating STDEV for non zeroes 1
VBA macro to average 4
Insert a text in Column A and calculate the average from column B 7

Back
Top