Office & productivity software forum: I need a excel macro code to carry out a formula.

If Nt is unknown, then 1 to Nt is meaningless, and division by Nt is also meaningless.

I suspect you mean that Nt is defined elsewhere, perhaps in each workbook, but could be different for different workbooks.

What is Xave ? I haven't seen that mathematical expression before. Or do you mean an average of all the entries in col A?

Why do you need a macro for this? If there are explanations for the Nt and Xave above, then I'm sure the formula you have given can be worked into any cell, eg F2, even if it has to be worked on a bit.

Any new columns can be hidden of course.

But then your expression starts with D = .... What is D?

Mark

and thanks for that CNN80.

I can also see now why you need that macro.

Hopefully others here will be able to help with that, but what about working with this in the meantime...?

You may want to work on a couple of dummy, (copied), sheets, saved in a completely different location, in case you make an error and lose anything. In fact, I would copy all of the original workbooks and place them off the hard disk somewhere, a backup.

Do this manually once more. But before doing it, "Record a macro", by going to Macros > Record a macro. Fill in the blanks, Macro name, Shortcut key if you want it, or create an object button, and make it available for any worksheet.

Then carry out the steps you would do manually to make this formula work. When you're done, Stop the recording.

Since all of your data is presented in the same form and same cell locations in each sheet, that same macro should work for each.

Would that work?

Good luck.

Mark