Please rethink your problem and then describe it accurately. At the moment, youseem to have a perfectly good formula and you want to average some columns. Neither of these needs VBA.What exactly are you looking for?