Ah yes thank you both it seems to be working now. I've been trying to reposition it to another part of the worksheet but can't seem to get it to work...can you tell me for example how i could get it to start from cell D15 ?