thanks for the quick reply, so it looks like I need to use code to do this rather than entering a formula in cells? But how do I get to the place in excel where I enter the code you providd? Thanks