How did you try? Manually or with VBA?

It sounds as though the numbers in your column are results of a
formula.


On Oct 4, 9:43 am, wardle86
wrote:
I try and do it but the cells then just cpme up with #ref! in them, why is it
doing this?