thank you for this very much! however I have noticed a problem, if there is a blank cell then the marco stops and an error shows with Run Time error 12 Type mismatch, how can I get the marco to run around the blank value