Hi! I am new in VBA programming and I will be gratefull if someone help me.
My problem is: I have got row data from measurement.The data fill Column A and Column B. I have to work with every cell in column B and calculate their averaged value.For example, at first average of B1, next average of B1 and B2, next average of B1, B2 and B3 and etc.I have used loop for this(but it doesn´t work). Along this, I should compare averaged value to the value of the next cell(for example, average of B1:B10 compared to B11). If the difference between average and the value of the next cell is greater than 0,0004, the loop should stop and the average should be displayed in cell C1.
I have tryied some variants but they didn´t work.
Please, can you offer me some code for my problem.
Thank you in advance.
My problem is: I have got row data from measurement.The data fill Column A and Column B. I have to work with every cell in column B and calculate their averaged value.For example, at first average of B1, next average of B1 and B2, next average of B1, B2 and B3 and etc.I have used loop for this(but it doesn´t work). Along this, I should compare averaged value to the value of the next cell(for example, average of B1:B10 compared to B11). If the difference between average and the value of the next cell is greater than 0,0004, the loop should stop and the average should be displayed in cell C1.
I have tryied some variants but they didn´t work.
Please, can you offer me some code for my problem.
Thank you in advance.
