Why would you want a macro to do this. Formulas would be simpler