VBA doesn't copy the AVERAGE

Please Login or Register  to view this content.

I am good with the second section. It copies the old and new values to the ranged cells. But the first section doesn't work. Neither it is taking the average, nor copying the new value to M66 and old value to M67.

What am I doing wrong?!?!

Maybe:

Please Login or Register  to view this content.

Dom

1. There no need to insert the formula repetitively.

2. There no call to EnterFormula in the code that appears. If it's called from VBA, it should be in a code module, not the sheet module. If it's called as a worksheet function, it won't work regardless of where it appears.

Originally Posted by shg

1. There no need to insert the formula repetitively.

2. There no call to EnterFormula in the code that appears. If it's called from VBA, it should be in a code module, not the sheet module. If it's called as a worksheet function, it won't work regardless of where it appears.

Both fair points.

Dom

Originally Posted by Litstone

Unfortunately not

What? Does it not do what is required? Does it not work at all?

Have you followed Shg's advice about the location of the code. At the moment it will not run automatically if that is what you are expecting it to do.

A bit more info would be useful.

Dom

So it is getting more clear because my cells ranged from M6 to M47 contain formulas, too.

In tis case I have to write them too with macro. So is this a true definition?

Please Login or Register  to view this content.

So at the and it should look like that but I could make it Run:

B6:B47 called from external source.

Please Login or Register  to view this content.

Kur.xlsm

I am feeling like a dummy blond crash test mannequin

The thread is marked Solved -- is it?